G
Guest
Hi All,
I have an Access application that's basically 3 databases. One of them
linked to the tables on the other two. The other one is really a "front end"
with VBA code.
Security is controlled at user level (Read: work group file)
The application shortcut uses the command line parameters i.e.
[Access Path] [Database file path] /excl /wrkgrp [work group file]
The application is installed by an account that has Admin privilege.
If someone else without Admin privilege logs on, and tries to open the
application (clicking on the command line supplied shortcut), it says "Access
can't find the database file"
The weird thing is, even if you double click on the database file from
Windows explorer, it shows the same error.
When the non-Admin user tries join the work group, it says "Access Denied"
How can a non-Admin user use this secured database without, well, becoming
an Admin user?
I hope I explained it.
Any help is appreciated.
I have an Access application that's basically 3 databases. One of them
linked to the tables on the other two. The other one is really a "front end"
with VBA code.
Security is controlled at user level (Read: work group file)
The application shortcut uses the command line parameters i.e.
[Access Path] [Database file path] /excl /wrkgrp [work group file]
The application is installed by an account that has Admin privilege.
If someone else without Admin privilege logs on, and tries to open the
application (clicking on the command line supplied shortcut), it says "Access
can't find the database file"
The weird thing is, even if you double click on the database file from
Windows explorer, it shows the same error.
When the non-Admin user tries join the work group, it says "Access Denied"
How can a non-Admin user use this secured database without, well, becoming
an Admin user?
I hope I explained it.
Any help is appreciated.