• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 255
  • Last Modified:

How do I edit microsoft access runtime version

I have an installed an application that is a simple inventory system which is uses microsoft access. I need to edit a report in the database but when I click on the database file and not the application I get a visual basic error and then when I stop debugging the program is stuck at loading program. Our company owns the database out right and we have a full blown version of access but it seems as the application is using microsoft access runtime. How do I just open the database to make changes.
1 Solution
Are you attempting to open an .mdb file?  If so, hold down the shift key when opening the file to see if that will bypass any startup events/autoexec macro.
OM Gang
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>when I click on the database file and not the application
Explain.  Both mdb's, front-end and back-end?

>and we have a full blown version of access
You'll need to move this app onto the pc that has the full-blown version, then run it.

If that pc has both full-blown version and runtime, it would be best to note where the full-blown executable is, then reference it in the shortcut.
"c:\Program Files\Microsoft Office\Wherever your full-blown version is \msaccess.exe" "c:\yourapppath\yourapp.mdb"
tupac1979Author Commented:
that was it holding down the shift key. Thanks

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now