People using access database ast once (ASP)

[bonfire89]

Hi, today I was testing out a forum with a budy of mine at school today, and then I cam accross this error

Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver]
The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.

I never thought about this before. Is there a way to fix this? and How.

Thank You.

 

[Mucman]

Make sure you close your database connections.

 

[bonfire89]

yeah, they are all closed as soon as they can be in the program...thanks though...There is a person at my dads office who knows asp, so i e-mailed her...hopefully i should have a response on monday, and I can post it.

 

[Mucman]

I know ASP, I just don't touch Access 🙂. All my apps use MS SQl Server 😀

 

[Shazam]

You encountered a deadlock.

Try to find out exactly what queries the people were running. See if you can modify your queries so that you minimize the number of DML statements you are doing. As a last resort, change the isolation level of the queries to serializable.

MS databases in general have a hard time with deadlocking.

 

[Nothinman]

See if Access has any row locking ability or move to a real database.