I have an asp.net application running on a server... (www.skint.co.za) please excuse the graphics, it is very much in test stage.

My problem is that i have to use an access database as opposed to the usual SQL server.

The program runs all fine and well, except that after the first "write" call to the server datdabase, the server puts a lock on the file (.ldb). This is very annoying, as the lock even locks the application itself from writing, and the site goes into a read-only state, meaning i cannot upload any information!

Surely the lock should be user specific and the application on the server should be able to write to the db?

Any ideas anyone?