Help with multi-user environment

[Matt]

What I would like to accomplish is this; I would like to, when I open my
database, be able to see WHO else is using it. The message that I don't have
exclusive use is dandy, but I need to know who to knock off when I need
exclusive use.

 

[Douglas J. Steele]

Why would you need exclusive use? Is your application split into a front-end
(containing the queries, forms, reports, macros and modules), linked to a
back-end (containing the tables and relations) like it should be? With that
set-up, you make the changes in your copy of the front-end, and simply
redistribute it to all other users.

If you think you've got a legitimate need, though, take a look at
http://www.mvps.org/access/modules/mdl0055.htm at "The Access Web"

 

[Matt]

I am experiencing a lot of lag when I work on the front end while the back
end is in use. Maybe it's not the source of my issue though.

 

[Tony Toews [MVP]]

I am experiencing a lot of lag when I work on the front end while the back
end is in use. Maybe it's not the source of my issue though.

Performance problem.

The three most common performance problems in Access 2000 or newer
are:
- LDB locking which a persistent recordset connection or an always
open bound form corrects (multiple users)
- sub datasheet Name property set to [Auto] should be [None]
- Track name AutoCorrect should be off

For more information on these, less likely causes, other tips and
links to MS KB articles visit my Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm

Tony
--
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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/