HI All,

Could some body enlighten me to a prob. that I have with inserting records into an access relational database via an asp insert record page? The problem that I am getting is that after I insert the record the database is locked up & can be browsed via my asp pages, the records are inserted just fine & can keep being inserted, I can also open the database up in access & view my records OK... The only way I have found to superficially fix this problem is to re-create my DSN, but once I try to insert again I get the same problem...

I don't get this problem with unrelated database tables, they work just fine...

The errors that I am getting are:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.
/amazingtiles/products.asp, line 25

& when I refresh the page the error changes to the below error:

Error Type:
Provider (0x80004005)
Unspecified error

The way the database is related is:

atcategories table (relates to the) atsubcategories table (which relates to the) atproducts table - referential integrity is off.

Any suggestions or help would be greatly appreciated.

Regards

Billy Brackman

Take a look at this:

www.udzone.com/forum/topic.asp?TOPIC_ID=9791&FORUM_ID=7&CAT_ID=5&Topic_Title=HTTP+500%2E100+%2D+Internal+Server+Error&Forum_Title=ASP


Regards

Owen.