Only desktop db shortcut generates exclusive mode

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

Guest

I have a new user that I gave a Windows login and a database login to. The
database login is to a custom designed Access 2003 db, front end and back
end.

On her computer and her computer only, I can open up a database through File
| Open, then navigate to the network drive where the database is located and
open it. All is fine. I can also start Access then use select from the
"last four" dbs list to open the database. All is fine. She can use the
database.

However, when I put a shortcut to the database on the network drive where
the database is located, and she double clicks that icon, an error message
displays (after she enters her database login and password) talking about not
having exclusive access at this time. The error message never goes away.

Like I said, this message only happens on her computer. I tried her db
login on my computer and all is well.

She is running Office 2003 with all updates and service packs applied. I
uninstalled Office, deleted the Microsoft Office folder and reinstalled
Office. The error still pops up.

I made her a Windows XP power user. Did not help.
 
Flick Olmsford said:
I have a new user that I gave a Windows login and a database login to. The
database login is to a custom designed Access 2003 db, front end and back
end.

On her computer and her computer only, I can open up a database through File
| Open, then navigate to the network drive where the database is located and
open it. All is fine. I can also start Access then use select from the
"last four" dbs list to open the database. All is fine. She can use the
database.
Click to expand...

I'm not sure that is fine, unless her computer is joined by default to the
secure mdw. Is she prompted for a username/password?
However, when I put a shortcut to the database on the network drive where
the database is located, and she double clicks that icon, an error message
displays (after she enters her database login and password) talking about not
having exclusive access at this time. The error message never goes away.

Like I said, this message only happens on her computer. I tried her db
login on my computer and all is well.
Click to expand...

She should have a copy of the frontend on her PC. You shouldn't have
multiple users using the same frontend on the server.
 
There are ways you can automate updating the frontend to the users. You
really don't want to share the frontend - there's a risk of corruption.

See www.granite.ab.ca/access/autofe.htm for some methods.

If you don't want to have the computers joined by default to the secure mdw,
you can leave them joined to system.mdw and give them a desktop shortcut with
the following in the target; that'll override the default and use the secure
mdw for just that session of Access.

"path to msaccess.exe" "path to frontend" /wrkgrp "path to secure mdw"
 
She is prompted for a user name and password. I even tried removing her db
login and adding it again under another ID number.
 
Back
Top