Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2009-04-09
3
Medium Priority
?
942 Views
Last Modified: 2013-11-29
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?
0
Comment
Question by:Chuck Wood
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 24113045
The ACCDR is NOT readonly unless you make it so. That extension simply tells Access to run the database in Runtime mode.

Does this happen on multiple machines, or just one? It sounds suspiciously like a bad Runtime install, but if this occurs across more than one machine then the culprit would be your application, not Access.

If you test the db using the Runtime ONLY (i.e. a machine without the full version of Access installed), do you get the errors?

Did you install the db to a Trusted Location?
0
 
LVL 16

Author Comment

by:Chuck Wood
ID: 24116757
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.
0
 
LVL 16

Author Closing Comment

by:Chuck Wood
ID: 31568726
Great and complete answer. Thanks.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

598 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question