Access Timeout

[Guest]

Is there a way in which I can automatically time out of my shared access
database. Or, can I see a list of who is logged into the shared database.

My situation is I have a shared database with about 20 users in 3 offices.
When I run make table or append queries, the database is really slow unless I
am the only user on the database. I would like to be able to either have
sessions not being used get closed or else see a list of those individuals
using the database so I can make sure they don't just have it opened on their
desktop.

 

[Douglas J. Steele]

Take a look at http://support.microsoft.com/?id=210297

 

[Tony Toews]

When I run make table or append queries, the database is really slow unless I
am the only user on the database.

Try keeping another table open at all times while you are doing the
make table or append queries. Or keep a bound form open at all
times.

I'm not sure that this is your problem but it's worth a try.

Ton
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm