Active Server Pages (ASP) Access Database Errors

[sukishan]

Active Server Pages (ASP) Access Database Errors

Some of the most common questions asked on the Web Wiz Guide Forums are from people getting errors when using Microsoft Access with ASP. So in this article I'm going to try and explain what a few of the more common errors mean and how to solve them.

Common Access Database Errors
* Cannot update. Database or object is read-only
* Operation must use an updateable query
* General error Unable to open registry key
* Could not find file
* Could not use '(unknown)'; file already in use
* Table 'tblTable' is exclusively locked by user 'Admin' on machine 'MyMachine'
* Too few parameters. Expected 1
* Either BOF or EOF is True, or the current record has been deleted
* Item cannot be found in the collection corresponding to the requested name or ordinal
* The search key was not found in any record