Access on the web - can it handle simultaneous queres?

[SSJpn]

We have a small site linked to an Access 2000 database. The site is for our employees so there are no more than 70 users of our site.

What happens if one user is submitting a form (logging the information into the database) at the same time someone else is quering the database for information. Or what if two or three people try to write data to the data base at the same time?

Can Access handle this? Does it return an error? Does some of the information get lost?

Thanks.

 

[quest4]

Good morning SSJpn. Yes Access can handle it if the dbase is designed to handle it. Yes you can get errors with 2 or more records tring to get the same PK at the same time. A few quick rules to help prevent your problems, never use Access autonumber or DMax for your PK, though DMax is great for sequential numbering in subforms. Try using Pesimistic Locking on your forms, which will keep 2 people from modifing the same record at the same time, picture that one. You can find PL in the FAQ section, there is a good version there. As far as sequential numbering goes just try search, there is a ton of posts and examples for that one. Hope this helps you out.