hey guys,
I've just finished updating an access database which I uploaded onto a shared folder in a server.
Since there are going to be other people who will be accessing the database, I need to give them "Read-Only" rights, saving the editing features for myself alone.
I've tried to do it using the Security Wizard and it gave me a shorcut on my desktop. I copied the shortcut onto another persons PC and it worked. That person had the correct rights and everything. But a problem arose when a person with Office 2007 tried to copy the shortcut and use it. The shortcut seemed to be linked to my PC. Is that true? Since then, I've reverted to the backup and removed all security options altogether.
How do I create user accounts and passwords for the database while the file is on the shared folder?
Julz