Locking errors over a network

[Guest]

Has anyone split database into a front and back end. I've a 'locking' error
whenever more than one computer has another version open. Its set up so that
the front end linked tables can be shared with any PC on the same Network.

One error message says; System has been placed in a state" can not be opened
or locked. I thought if it was split this wouldn't happen. I need many users
to access this database simulataenously any ideas?

Many thanks

Nick

 

[Guest]

Nick,

The concept, as developed by Micorsoft for using Access in this way, is to
put a copy of the front-end on each users machine and have it linked to the
backend, located on the network.

 

[Albert D.Kallal]

It sounds like you split the database, but you do you place a copy of the
mdb (or perffred mde) on EACH computer?

IF you are mixing versions of ms-access, then the above is a requirement if
you want any stability...

 

[Guest]

Thanks Albert - very helpful. working now.

Nick

 

[Guest]

Thanks Albert - very helpful. working now.

Nick