Access over a peer to peer network

[geeves1293]

Hello all,

I have had my splendid access program running over a peer to peer network
for over a year now working fine.

Now the new year has arrived it seems though only some users (2) cannot
access it when someone else is using it. Its fine if nobody else uses it.

Each computer except the host has a mapped network drive connecting to the
shared folder on the host.

Any help would be much appreciated.

Many Thanks

Geeves 1293

 

[Paul Shapiro]

Are the 2 users who cannot connect when anyone else is using the db trying
to open it exclusively? Look in the Access options on their machine.

Have you split the application into a front-end db containing links to the
tables in the backend db, and does each user run a local copy of the
frontend? The backend should have only the tables, and the frontend should
have all the forms, queries, reports and code.

 

[geeves1293]

Thanks for relpying.

The 2 said users are opening it as shared.

The databased is not linked, all in one db.

Thanks

Geeves1293

 

[John W. Vinson]

The databased is not linked, all in one db.

Then split it... *soon*. Sharing a single database over a network will cause
bloat, poor performance, and risk corruption.

See http://www.granite.ab.ca/access/splitapp.htm for a thorough analysis.

 

[geeves1293]

Thanks John

I split the database into back & front like suggested. Set up the
complicated paths using link manager and all works fine.

Thanks for yours and Paul Shapiro's help.

Geeves1293