We are using MS Access2000 with ASP. However, two or more customers can't submit the order at the same time. Can Access2000 accept multiple users using at the same time? It looks like that it won't allow the 2nd user to save any changes until the 1st user has closed his program. Is there any way to fix this? Where should we change the configure? Is it related to the server side?

Your response is greatly appreciated.

If you're using asp what does the first users closes program mean. You can't mean the user has Access open, do you? This doesn't sense if you're using ASP.

If you're using asp what does the first users closes program mean. You can't mean the user has Access open, do you? This doesn't sense if you're using ASP.
True. If someone has the file open in MS Access then the website may have problems opening it simultaneously. Noone should be opening a MS Access database directly from MS Access if it's being accessed by the website also.

In the ASP script, once you open the database table, you must close it after you have received the data. It goes the same for posting data to the database as well. Many forget to do a <ServerObject>.Close at the end of their function or ASP coding which will keep it opened until IE/Netscape is closed or until it is released by the server.

Windows does a pretty good job of closing the open connections for you, though it's not perfect.

If you can't connect two people to the database at once you have something profoundly wrong with your set up.

Check that the database / dsn is not set for exclusive use.

always close the connection when the data is transmited.
You can have lots of ppl access the data at the same time without any problem.