read only error in access 2000

I am getting a "read only error" when i open up my access 2000 database and my database is linked to a webpage. But once i reboot the server, everything is ok. The problem is that it is happening three or four times a day. I have gone to the tools/options and checked exclusive under the advance tab, but i am still having the same problem. Basically, my database is freezing up and not allowing my users to input any updates through the webpage.

Someone please help.

C'mon there has got to be one genius out there. Please help a brotha out....lol.

You are sure that you don't have any code the sets you DB to a read-only status?
S-

Yes, i've checked all the code. Its weird because all of sudden it stopped "freezing" up and i'm sure it will start doing it again in a couple of days. Any ideas?

It also seems to start "freezing" up when the website is under heavy use or when my users are inputting many changes. Could there be a number of users restriction somewhere in my database?????

How many users are hitting this Access DB at a time?

S-

Over 100 at any one time.

Look up "Microsoft Access specifications' in the help, this will give you some general specifications about how many users can HIt Access at a time (MS claims 255 concurrent users), but I don't know how realistic that is. It will depend on how you have your recordlocking set up. I would look into how you are locking records. If I remember correctly access locks a page of records (can't remember how many records in a page), not one record at a time. It is possible that with that many users you could have users that are locking records and them have other trying to hit and edit a record in the same page and can't (woud be locked). It is also possible that you code doesn't close the record locks and is leaving the data locked when the users is done editing/adding the record.

I don't know what else to tell you, typically if I have that volume of concerent users I start looking for another DB. You could try MYSQL (it is free). I haven't done anything with it, but I know it is out there.

Good Luck

S-

I found more information of how to do record locking in MS Access 2K

http://support.microsoft.com/defaul...kb;en-us;238258

http://support.microsoft.com/defaul...kb;en-us;306435

http://support.microsoft.com/defaul...kb;en-us;225926


Don't know if any of this will help... Have fun!

S-