Multiple Users Inserting Data

**RFH Reseller: s80wkr** · 22nd February 2006, 10:59 AM

I have an access database and possibly multiple users inserting information using a web page

In the past I have experienced problems with the database when 2 people are inserting information at the same time

Is there any way to add into the script

if an insert is happening just wait a moment then insert

Thanks

**Staff: Warren Ashcroft** · 23rd February 2006, 02:38 AM

Generally the data provider does this automatically (depnding upon the connection options) - what "problems" are you having?

**RFH Reseller: s80wkr** · 24th February 2006, 02:29 PM

The database would lock and the asp page would hang and I would have to go in a delete the db and then reupload it

Seemed to happy if more than one person was inputting data

**RFH Reseller: Sol** · 24th February 2006, 03:09 PM

This is one of the main reasons not to use MS Access, especillay as it locks the whole database and not just the tables currently being used.

To be honest, I have also experienced this with MS SQL under very high loads and spent considerable time re-working the application.