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

MS Access database application won't open on Windows 7 / MS Office 2010

Hi experts,

We are currently migrating our platform from Windows XP to Windows 7 Enterprise and we are having several MS Access 2003 (Access 11.0) applications/forms that won't open using the MS Access 2010 runtime application.

Here is the message I'm getting :

A potential security concern has been identified.
Warning: It is not possible to determine that this content came from a trustworthy source.
You should leave this content disabled unless the content provides critical functionality and you trust its source.

File Path : C:\Users\.... (the path where the database resides)

This file might contain unsafe content that could harm your computer. Do you want to open this file or cancel the operation?

followed by this message :

Execution of this application has stopped due to a run-time error.

The application can't continue and will be shut down.

I had a look in the Windows Event Viewer and I got a little extra information about the error :

Microsoft Access
Execution of this application has stopped due to a run-time error.
The application can't continue and will be shut down.
P1: 507898
P2: 14.0.4763.1000
P3:
P4:

Any thoughts?

Is it possible to open MS Access 2003 databases with the Access 2010 Runtime application?

Thanks
0
SolutionsTI
Asked:
SolutionsTI
3 Solutions
 
Tyler LaczkoCommented:
you need to go into the options of access an allow security to the file.
0
 
Tyler LaczkoCommented:
access options
trust center
trust center settings
trusted locations
add new location
0
 
SolutionsTIAuthor Commented:
OK.

I tried opening the MS Access runtime (C:\Program Files\Microsoft Office\Office14\ACCESS.EXE) software and I get the following error:


Can't find the database you specified, or you didn't specify a database at all.

Specify a valid database name in the command line, and include a path is necessary.


Thank you for helping me out.
0
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.

 
SolutionsTIAuthor Commented:
I can access these settings from Excel or Word as it is included in the Enterprise edition of Office 2010, but the settings does not seems to be retained for Access.

Any idea?
0
 
peter57rCommented:
You need to set trusted folders for Office 2010.

I don't it's possible to do that in the runtime version so you need to change the registry.

Here is a link to a ready built app to do it...

http://www.accessribbon.de/en/index.php?Trust_Center:Trusted_Locations
0
 
SolutionsTIAuthor Commented:
Perfect. Now I can open the database a little bit further.

Now a small window opens for few seconds with the following message in it :
"Searching for referenced file : utility.mda"

.. and the following message appears :
Execution of this application has stopped due to a run-time error.
The application can't continue and will be shut down.

Thank you very much for help
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
The utility.mda is from an older version of Access. It may be from Access 97 an prior.

This utility.mda is not installed with Access 2007 or 2010  (full or runtime).


You will need to deploy the utility.mda with your Access application.

You might go into the  Access database with a full version of Access  and uncheck the utility.mda reference. Recompile to see if it is even needed.
0
 
SolutionsTIAuthor Commented:
It works!

For the knowledge base :
1. I opened the database in design mode (hold SHIFT while opening the database)
2. Tools > Macro > Visual Basic Editor (ALT-F11)
3. In Microsoft Visual Basic : Tools > References
4. Uncheck utility.mda
5. Done!
6. Close the database and open it in Office 2007 or 2010. It should work if your database application does not use utility.mda functions.

Thank you experts for help.
0
 
SolutionsTIAuthor Commented:
Requesting attention to give points to peter57r. My error. I am sorry.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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