Sharing Access database so that ASP can open it

[LWCARAB]

I have an access database which is shared, I can open it on 2 pcs at the same time no problem. I also have an html and asp page which is used to add recoreds to the database, this works fine if the database is closed everywhere else but this cannot be the case. I am now desperate for answer to any help would be greatly appreciated.
I have attached the asp file, I can upload all files and database to a server if someone requires them (too big for the forum).

Thanks,

Richard

 

[Rabbie]

It sounds as if the html and asp page is opening your db in exclusive mode. Make sure that no-one is opening the DB in Exlusive mode and see what happens.

 

[LWCARAB]

I've set the database to shared in tools, options, advanced so surely you can't open it in exclusive mode can you? I thought the default was shared anyway.

Richard