Access with multiple users hangs on screen save.

[steve]

I have a freind who uses Access 2003. Depending on who logged on
first their screen saver causes the db to stop working.

Here is what happens.

1. Person A. starts access and opens db. The db is on a remote
computer.
2. Person B. then starts and opens db.
3. When person A's computer screensaver comes on then it stops B from
accessing the db.

This works in reverse as well eg B opens db, A then opens db if B's
screen saver comes on it hangs the DB. The only answer is to have the
person who started the db exit from it.

Can anyone tell me how to fix this?

Regards
steve
7willie

 

['69 Camaro]

Hi, Steve.

Can anyone tell me how to fix this?

Split the database into a front end and back end. Place the back end, which
includes only the tables and relationships, on the shared network server,
and place a copy of the front end, which includes querie, forms, reports, et
cetera, on each user's workstation. For more
information on splitting the database, please see the "Split the Database"
tip on the following Web page:

http://www.Access.QBuilt.com/html/gem_tips1.html#SplitDB

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: http://DataDevilDog.BlogSpot.com http://DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[steve]

Hi, Steve.


Split the database into a front end and back end. Place the back end, which
includes only the tables and relationships, on the shared network server,
and place a copy of the front end, which includes querie, forms, reports, et
cetera, on each user's workstation. For more
information on splitting the database, please see the "Split the Database"
tip on the following Web page:

http://www.Access.QBuilt.com/html/gem_tips1.html#SplitDB

HTH.
Gunny

Seehttp://www.QBuilt.comfor all your database needs.
Seehttp://www.Access.QBuilt.comfor Microsoft Access tips and tutorials.
Blogs:http://DataDevilDog.BlogSpot.comhtt....QBuilt.com/html/expert_contributors2.htmlfor contact
info.











- Show quoted text -

Thank you I will take a look at it.

Regards