To many Users error?

S

Siddarth Shetty

When my mutiple clients try accessing the main server which is running
Access. I get error saying too many users logged in?
Is there a limitation for users to accessing it!

Let me know....

Best regards,
Siddarth.
 
R

Roger Carlson

If you look in Help under "Specifications" you'll see that Access has a
limit of 255 concurrent users. However, a single physical user can have
multiple connections to the database (depending on how it was developed) so
the actual number of people may be smaller than that.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
T

Tanisl

Hi, I came to this site because I am having a similar prob. it tells me that
two people are trying to change the same record, and there is one line in 3k+
records, datasheet that has error in every field, the system will not let me
delete this record I would just like to delete this record and move on, any
one????
 
J

John W. Vinson

Hi, I came to this site because I am having a similar prob. it tells me that
two people are trying to change the same record, and there is one line in 3k+
records, datasheet that has error in every field, the system will not let me
delete this record I would just like to delete this record and move on, any
one????
Click to expand...

You have a corrupt database. It may not be possible to delete the record
directly. Instead, create a new .mdb file; Import everything except this
table, and import this table, design view only (no data).

Then use File... Get External Data... Link to connect to the old database, and
create one or more Append queries to append all the records except this one.
Use the Primary Key as a criterion but DON'T reference the key of the damaged
record directly - i.e. if the primary key value of the damaged record is 1325,
use a criterion such as

<= 1324 OR >= 1326

Compact and repair the resulting database and manually reenter the damaged
record (or records).

See http://www.granite.ab.ca/access/corruptmdbs.htm for a thorough discussion
of database corruption.
 
Top