administrator access uac for my app?

General
1

Hi all.
It seems that every app I create that uses sqlite for data storage comes up with the same problem at runtime: administrator access is required to save to the database.

Is there a way I can get around this? It’s really annoying, and google hasn’t been much help. Any assistance would be greatly appreciated.

2

What is the path to the database file?

3

I’m sure it depends on the path where you or the user wants to store the sqlite database.

4

Peter was faster…

5

the db file is in the same folder as the exe.

6

I would suggest to use something like this:

SpecialFolder.ApplicationData.child("Appfolder").Child("app.sqlite")
7

Thanks, Michael. I’ll give that a try.
Meanwhile, is there another way as well? If possible, I’d like to try and keep my apps portable.
Sorry if I’m being a headache.

9

I’d be interested in this for sure. Can you please either post it here, or PM me?

Thanks!

10

Thanks, Dave. I have no idea what you’re talking about, but I’m always willing to try. :slight_smile:

11

The Windows app ResourceTuner allows you to change your EXE to run with Admin rights.

12

That is your problem. Move the database file to SpecialFolder.ApplicationData and everything will be fine.

Any copy, save or modify in the Program Files(x86) folder has to get administrator approval. Xojo or not.

Placing data files next to the executable is simply not a good idea.

13

[quote=184895:@Michel Bujardet]That is your problem. Move the database file to SpecialFolder.ApplicationData and everything will be fine.

Any copy, save or modify in the Program Files(x86) folder has to get administrator approval. Xojo or not.

Placing data files next to the executable is simply not a good idea.[/quote]
Thanks for the info, Michel…very much appreciated.

14

Thanks, David. Googling now. :wink:

15

Well, Michael’s info corrects the problem for installed apps, and David’s suggestion solves it for portable AND installed apps.
Call me a happy camper…thanks guys!!! :slight_smile:

16

I’m getting an error in the debugger that says “Parameters are not compatible” using this code:
dim f as FolderItem f = GetFolderItem(SpecialFolder.ApplicationData.child("pae").Child("log.sqlite"))

17

f = SpecialFolder.ApplicationData.child(“pae”).Child(“log.sqlite”)

SpecialFolder.ApplicationData is a folder object so you don’t need to get it.

18

[quote=185102:@Wayne Golding]f = SpecialFolder.ApplicationData.child(“pae”).Child(“log.sqlite”)

SpecialFolder.ApplicationData is a folder object so you don’t need to get it.[/quote]
Thanks Wayne! Sometimes I guess I just miss the obvious. :wink: