Multi-user impact question

[Guest]

I maintain a database (split) with about a dozen users who update the
database. I have now been asked to give access to 60 more people for inquire
only access. I doubt whether all these 60 people will be using the database
at the same time, but assuming they were, what impact would this have on the
updaters? The design of the application is such that there is a search screen
and then the ability to pick one record at a time to view. If someone has the
application just sitting open on the search screen, is there any impact since
no records are being held?

 

[Guest]

Do all the users have a copy of the FE? If multiple users are on the same FE,
you could have troubles.

Otherwise I'd think that Access could handle it as, per Microsoft, Access
can handle 255 concurrent users.

There are some utilities out there to disconnect inactive users.

 

[Tony Toews [MVP]]

I maintain a database (split) with about a dozen users who update the
database. I have now been asked to give access to 60 more people for inquire
only access. I doubt whether all these 60 people will be using the database
at the same time, but assuming they were, what impact would this have on the
updaters?

None, read only users, assuming you don't hit the 255 user limit,
aren't a problem.

The design of the application is such that there is a search screen
and then the ability to pick one record at a time to view. If someone has the
application just sitting open on the search screen, is there any impact since
no records are being held?

No.

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/