Dont have permission message

[Janet]

I have a multiuser database that I have set up. It is on
a network. I have set up the security through using the
security wizard. When I go into the database through the
shortcut on my desktop it lets me do everything. When I
try to go to the server and access it, it tells me I do
not have permission and wont even let me open the
database. No one else can open the database either. Any
suggestions?

Thanks,
Janet

 

[Annelie]

You need to know where you security.mdw is located. Below list is a sample
to the shortcut which needs to be created on each computer, pointing to the
right directories. the first part list where the office program is located,
2nd part is where the workgroup file is (usually where the datafile is) and
the 3rd where the security file is located. Copy the below line into your
notepad. Find out where your files are located and make the appropriate
changes to the line- this is one line, no returns.
Right click on the desktop and create a new shortcut. copy and paste your
adjusted line into the shortcut. Then use the shortcut to access the
database.

"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE"
C:\DATA\ACCESS\EMPL-Time2003.mdb /wrkgrp C:\DATA\ACCESS\Security.mdw