Why not just use internal Access Security. It would give you more control than just access into the db.
Here are instructions that I have written.
I would add users level security. This allows Access to know how many users are in the db. It also will fix any write errors that may occur.
Here is the instructions to implement security.
I recommend setting up ueser level security. This will allow you to give right to specific items in your db. Here are the basics of setting up security. User level security also helps to aviod write errors your users may have.
1. Set up a mdw file for your db. Use the help instructions in Access for a Workgroup file.
2. After you create the new mdw make sure to rejoin the system.mdw file for your copy of access.
3. Create a shortcut in the target line you will need to fix the sytax. Here is a copyu of one of mine.
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" V:\Puball\UM\Discharg.mdb/wrkgrp V:\Puball\Um\Discharg.mdw
V is the network drive. DOn't go lower than two folder levels. I had trouble and that was an issue.
The shortcut launches access then your db and the associated workgroup.
Once you get the shortcut working. Go into tools, security, user and group accounts. Add you users. Then distribute the shortcut. Make sure to have a working copy of the shortcut on the network so you can retrive it for distribution.
This will allow all users global access to the db, but will fix your Write errors.
Let me know if you have further questions.
HTH
Danny
