Link to home
Start Free TrialLog in
Avatar of Chuck Wood
Chuck WoodFlag for United States of America

asked on

Access 2007 Runtime Deployment Cannot Delete or Update Records in Local Tables and Opens Read Only

I have an Access 2007 database (.accdb) and I have Access 2007 Runtime installed, as well as the full version of Access 2007. When I run it with the /runtime switch from a shortcut, it works fine. When I package the solution from the Package Installation Wizard and install it from the package, it fails serially to delete records in local tables and load the local tables from the back end, which is part of the startup process. It errors at each table that should be cleared and loaded. The error is -214746259 "Could not delete from specified tables" followed by -214746259 "Operation must use an updateable query" with a source of Microsoft Office Access Database Engine. It then opens the datbase read only, which does not occur when running the database from a shortcut.

Is there something I am doing wrong in the solution packaging or is it just that the .accdr runtime version is by definition read only? If the problem is that .accdr is read only, how can I work around this to develop a solution package that is not read only?
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Chuck Wood

ASKER

How can I uninstall the Runtime so I can reinstall it?

I haven't yet tested the db using the Runtime because I am on Vista and Windows 2000 on my two computers and I have to find a machine with Windows XP to test on. I will do that next week.

I changed the installation location to a trusted location and I still get the errors and the db open Read Only.
Great and complete answer. Thanks.