Permissions question

[sv001]

hey guys,
i'm developing an application for a client that uses an Access database as its backend. they're going to install the application on about 15 computers which all connect to this one database.
the problem is, my program crashes on the client unless the user running the program has admin rights on the pc. is there any way i can have the program run on a user who doesn't have admin rights on the computer/database? i haven't found a way to do that so far.

thanks.

[RudyL]

The most likely problem is that when accessing the database a lock file needs to be created (Access does this automaticly).. If the user does not have write access tot he drive then the lock file can not be created.

The reason it is crashing is probably because you are not handeling the error correctly (or at all)..

Rudy

[sv001]

yeah i figured it's because the user doesn't have read/write access to the folder. now my next question is.. what is the best way to do this without giving the user read/write access to the folder?
is it possible for me to..say pass a windows username and password that is an admin through the program so that it's able to read/write the database? i want it so the program can access the database but not the user.
any suggestions?

thanks

[RudyL]

If using an Access database you are really tied to two option...

Give the user access or use a real database setup like Oracle..