Help - Shared MDE - Exclusive Access message box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear firends,

I did some research and found several articles about this issue but none
helped to resolve.

I have a MS Access 2003 database having 3 files:
1. MDB - Back End file (contains: data)
2. MDE - Front End file (contains: forms, reports, queries, VBA)
3. MDW - Security file (contains: users and groups)

All 3 files are located on a server. There is a shortcut placed on user's
desktop. The shortcut points to MDE file and includes /wrkgrp for the MDW
file. All the users are in same custom group in MDW file having Admin
permissions.
When the first user logs in, everything is fine. Then any consecutive users
logs in, they get message box saying:
"You do not have exlusive access to the database at this time. If you
proceed to make changes, you may not be able to save them later."
This message box appears about 30 or 31 times.

My question is that the short cut is opening a MDE file and the user has
Admin permissions both in MDW and Windows folder, so why does MS Access 2003
displays this message box ? Is there any resolution to this issue ?

Please help.
Thanks.
 
Suraj said:
Dear firends,

I have a MS Access 2003 database having 3 files:
1. MDB - Back End file (contains: data)
2. MDE - Front End file (contains: forms, reports, queries, VBA)
3. MDW - Security file (contains: users and groups)

All 3 files are located on a server. There is a shortcut placed on user's
desktop. The shortcut points to MDE file and includes /wrkgrp for the MDW
file. All the users are in same custom group in MDW file having Admin
permissions.
Click to expand...

Each user should have a copy of the frontend MDE on their local workstation.
Otherwise you risk corruption in the frontend. I do find it odd that you
would put all the users in a group that has administer permissions in the
database.
When the first user logs in, everything is fine. Then any consecutive
users
logs in, they get message box saying:
"You do not have exlusive access to the database at this time. If you
proceed to make changes, you may not be able to save them later."
Click to expand...

That is another reason to give each user their own copy of the frontend.
You'd need to modify their shortcut to point to the location of the frontend
on their computer. They can still use the MDW on the server. Make certain
that all users have the proper Windows permission on the folder where the
backend/mdw are located (modify permission is needed).
This message box appears about 30 or 31 times.
Click to expand...

That is due to Adobe version 7. To fix...
Control Panel, Add/remove programs, find Adobe, click Modify -> create Adobe
PDF. Expand to Acrobat PDF Maker and expand to locate Access; deselect the
add-in for Access.
 
Dear Joan,

Thank you very much. Removing Access plugin from Adobe PDF Maker helped in
resolving this issue.

Thanks,
Suraj.
 
Back
Top