P
Peter the grate
I have developed an application using access 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). 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 hte first query that updates a table. The two files mde and mdb
appear to be read-only (they can't be deleted 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.
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). 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 hte first query that updates a table. The two files mde and mdb
appear to be read-only (they can't be deleted 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.