Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error Deleting Record in Access DB

Status
Not open for further replies.

WMXTeam

Programmer
Oct 5, 2005
41
US
We have an ASP application that uses an Access Database. In the development environment, I am getting the following error whenever we try to delete a record from a table: "Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only."
We can add and edit records with no problem in the development environment.
In the live environment, records can be added, edited and deleted with no issues.
I think this is a permission issue because the development machine is new since I last worked on this application. However, I have been unable to solve it. FYI - we are using a DSNless connection in this application.

Any help is greatly appreciated.
 
Are you using anonymous authentication? If so, what rights does IUSR_computername have to the folder containing the MDB file?
 
After many more hours of troubleshooting, we determined that the query we were using to delete the record had been changed to a join query on the development environment. DUH!

Thank you for your help and I apologize for wasting anyone's time.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top