Access 2007 db works differently on computers
Posted on 2012-03-30
I created an Access 2007 database on my computer. When I send it to my client (the also have Access 2007) they get an error that I do not get. It works fine on my computer. Help!
They get a Cannot delete from specified tables error at this line of code:
DoCmd.RunSQL ("Delete * from tblSecurityHospitalAccess")
I created a query instead and they get an Operation must use an updateable query error message:
DoCmd.OpenQuery "qryDeleteSecurityHospitalAccess", acViewNormal