Database Splitter

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
 
P

Pieter Wijnen

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

HTH
Pieter
 
S

SteveS

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
 
G

Guest

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
 
Top