Database Splitter

message from Oli on 9 May 2004

Hi

I have splite our database into front end and backend. The backend has been
placed on a remote server (as we have multiple locations) which I am an
administrator.

However, when opening the DB on more than one machine I get the error:-
"The Microsoft Jet database engine cannot open the file
"82.xx.xxx.xx\xxxxxxx_be.mdb. It is already opened exclusively by another
user or you need permission to view its data"

How do I get round this - I am going to need about 10 people using this at
any one time and didnt plan on having to write an ASP client.

TIA
OLi

anonymous replied to Oli on 10 May 2004

Hi Oli,

I've just finished setting up mine and this is what I
did. Split the table; on the server lies the data and the
table that are split. I then copied the table (with
queries, forms, reports on each of the user's desktop.
then on each user's computer I linked their table to the
data on the server and so far has worked great. maybe you
didn't make copies for each?

hope this helps a little
Linda
The backend has been
which I am an
get the error:-
exclusively by another
people using this at
client.

Pieter Wijnen replied to Oli on 9 May 2004

everybody needs to be able to create/modify files on the share

HTH
Pieter

"Oli" <oli@NOSPAMoliwoods.co.uk> wrote in message
news:c7lmj2$50r$1@sparta.btinternet.com...

Oli replied to Pieter Wijnen on 9 May 2004

they can and it dont work?! same msg.

=?Utf-8?B?U3RldmVT?= replied to Oli on 9 May 2004

Is the BE set to Shared mode? I know, a silly quertion, but I've been bit by it more than once when I *knew* it was in shared mode..... and it wasn't.

In A2K, the exclusive/shared option is Tools/Options/Advances tab. The Default Open mode should be Shared.

HTH

Steve

Oli replied to =?Utf-8?B?U3RldmVT?= on 10 May 2004

Thanks Steve - but the default is already shared!
Any other ideas?

Thanks
Oli

Archived message: Database Splitter (MS Access Error Message)