'Not having permission or database has been opened exclusively'

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Claudette Hennessy - 01 May 2007 21:36 GMT

My clients are used to sharing a db built in version 2000. I built them a
new one built in 2003, 2000 format. The user on the PC where the db resides
opens it OK. The second user can open it once. Subsequent tries elicit a
" not having permissions or the database is opened exclusively", or even a
"Access cannot find pathname for S/:MyDocuments/Shows/db.mdb". Copying and
renaming the database permits another round where both users can open it
once. On the earlier version db, the ldb file opens and closes as expected.
The new file is set to open shared. I suspect this is a version issue?
What to do? I saw the response to the FE,BE problems on network post, but
my users can open and use other files in the target folder including the old
Access databases.

Thank you in advance,
Claudette Hennessy

Reply to this Message

Scott McDaniel - 02 May 2007 11:53 GMT

>My clients are used to sharing a db built in version 2000. I built them a
>new one built in 2003, 2000 format. The user on the PC where the db resides
[quoted text clipped - 7 lines]
>my users can open and use other files in the target folder including the old
>Access databases.

Since users can open other files in the folder, I'd assume that the permissions are set correctly, but it's worth a
look. Rightclick on the folder and review the Security settings of the folder hosting the database, make sure the
appropriate groups have REad/Write/Create/Destroy permissions on the folder (so they can manipulate the .ldb lock file).

Next make sure that users aren't defaulting to opening the database in Exclusive mode. This is a per-user setting, so if
you have a user who locks others out review the settings on their machine, in their Access program.

>Thank you in advance,
>Claudette Hennessy

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com

Reply to this Message

david@epsomdotcomdotau - 06 May 2007 07:28 GMT

You have a network problem. Make sure that your server
has all service packs applied: it looks like you missed something.
This should have been fixed six months or a year ago.

(david)

> My clients are used to sharing a db built in version 2000. I built them a
> new one built in 2003, 2000 format. The user on the PC where the db resides
[quoted text clipped - 10 lines]
> Thank you in advance,
> Claudette Hennessy

Reply to this Message

ThomCarr - 11 May 2007 20:50 GMT

> You have a network problem. Make sure that your server
> has all service packs applied: it looks like you missed something.
[quoted text clipped - 22 lines]
>
> - Show quoted text -

Do your clients all have Access 2003?

Reply to this Message