Database Splitter

  • Thread starter Thread starter Oli
  • Start date Start date
O

Oli

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
 
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

HT

Stev
 
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
 
Back
Top