I have developed an application using access 2003 as front end and back end.
I am not using workgroup security (ie all users will be admin) the program
part is
distributed as mde and the back end as mdb, the package also includes Access
2003 runtime and a dll that I have written. The developer's extensions are
used to package the app (using the package wizard).
Defect Symptoms are:
I install the app on a stand-alone WinXP using an administrator account.
(The PC
is actually a simulated PC using Microsoft Virtual PC)
When I then try to open the db application using a (limited) user account it
fails on the first query that updates a table. The two files: mde and mdb
appear to be read-only (they can't be deleted or renamed by the user)
even though win xp describes them as read-write and the user can write
other files into the same directory.
The directory they are being written into is:
C:\Documents and Settings\All Users\Application Data\MyDir\
I have also tried writing them into a program files directory:
C:\Program Files\MyDir\
The application works just fine if the user is an administrator, but as you
know in many businesses, users are only given "limited user" accounts.
If you can't think of an answer, can anyone direct me to where I might
get an answer? As you can imagine, this is a "show-stopper" my application
development is effectively stopped until I can get a solution.
Peter
|