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. 

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

"Siddarth Shetty" <siddu@shirt-company.com> wrote in message 
news:A13DC421-D588-4BCF-9B41-E950CF158706@microsoft.com...
> 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. 

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????

"Siddarth Shetty" wrote:

> 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. 
> 
> 

On Tue, 18 Mar 2008 13:40:02 -0700, Tanisl <Tanisl@discussions.microsoft.com>
wrote:

>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????

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.
-- 

             John W. Vinson [MVP]