Shared database reports it is in exclusive use – Access 2003

Topic

New Reply

OK, this may or may not make sense, but here goes.
And this may well be a permissions issue rather than a database one.

I have a database in 2003 mdb format.
It is a shared database, and on some machines opens up as expected, which is shared.
Certainly on my login.
BUT, on some machines it opens up with a message to say that it is in exclusive use elsewhere.

As far as we know, it is not opened anywhere as exclusive, and the .ldb file is behaving correctly.
There have been no crashes or corruption.
It appears to only effect some machines.
It may be something to do with thin clients, but
I am not a network administrator, and do not have any control over this.

So, what I am after, is not a solution, it is a suggestion of where to look, to try and pinpoint the cause of the problem,
so we can investigate.
It may be that the permissions to the folder for some people ar set as Read Only.

Any ideas gratefully received.

Reply | Quote

Replies

The folder permissions being read only is one good possibility, but another is that the user has a default setting of opening it in exclusive mode. For some reason certain Access installations set that as the default – but you can change it on the open dialog.

Reply | Quote

Andrew,

Here’s what Wendell was refering to:
31208-Access-Open-Mode
:cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

Unfortunately the setting on the PC is not for exclusive.
I suspect it is something to do with user permissions, or maybe something on the thin client settings.
I reckon I am going to need to sit down with the Network administrator and look through the cases that show this behavior to see if we can find the cause.
If I do get to the bottom of it, I will post back here.

Reply | Quote

Hi Andrew,

Unfortunately the setting on the PC is not for exclusive.

Okay, for each affected user, try the following experiment as THAT user:Use Windows Explorer to open the shared folder. Then:

[*]Create a new text file in the shared folder. Add a single word or string of characters.
[*]Save and close the text file. Then re-open it. Try editing the contents.
[*]Close the file and try deleting it.

You should have success with each operation, when tested as that logged in user.

Also, it sounds like you may not (?) be running a split database or, if it is split, you are still sharing a common Front-End (FE) application file. In a properly split application, each user will have a separate copy of the Front-End (FE) application file installed on their local hard drive. This way, it is impossible for any two users to ever be sharing the same FE application file.

Implementing a Successful Multiuser Access/JET Application
http://www.accessmvp.com/TWickerath/articles/multiuser.htm
[/COLOR][/SIZE]
Also, see this “Gem Tip”:
http://www.access.qbuilt.com/html/gem_tips1.html#SplitDB
Note: For some strange reason, I had to try two times, before the above link worked. The first time I tried it, it opened up some kind of web-ring page. I’ve seen this before with these “access.qbuilt.com” links…

Reply | Quote