MS Access 97

[Karen A Friedman Electric Boat]

Replies to (e-mail address removed)

I have a multi user database with 100 users that typically
has 20 users with concurrent access. The notes on
the .ldb file say it can hold up to 255 users. Lately,
with a lot more users utilizing the system - we have had
corruptions. I kick everyone out. Repair & Compact & then
that lasts for a couple of days .. Then more problems. We
compact the database on a daily basis as part of our
standard maintenance procedures. I want to hear from
anyone running this type of environment. The database is
about 200MB in size right now (much below the 1G limit).
Any assistance - feedback would be appreciated.

 

[Bruce M. Thompson]

I have a multi user database with 100 users that typically

has 20 users with concurrent access. The notes on
the .ldb file say it can hold up to 255 users. Lately,
with a lot more users utilizing the system - we have had
corruptions. I kick everyone out. Repair & Compact & then
that lasts for a couple of days .. Then more problems. We
compact the database on a daily basis as part of our
standard maintenance procedures. I want to hear from
anyone running this type of environment. The database is
about 200MB in size right now (much below the 1G limit).
Any assistance - feedback would be appreciated.

Are these multiple users accessing the same MDB file? If so, see the following
page at Tony Toews' web site for the whys and hows on splitting your database
properly:

Splitting your Microsoft Access MDB into a front end and back end
http://www.granite.ab.ca/access/splitapp.htm

And, for help with your corruption problem, Tony also has an excellent resource
on corruption:

Corrupt Microsoft Access MDBs FAQ
http://www.granite.ab.ca/access/corruptmdbs.htm