Dont have permission message



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



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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question