asked on

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

Tyler Laczko

you need to go into the options of access an allow security to the file.

SOLUTION

Tyler Laczko

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SolutionsTI

ASKER

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.

SolutionsTI

ASKER

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?

ASKER CERTIFIED SOLUTION

peter57r

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SolutionsTI

ASKER

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

SOLUTION

Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SolutionsTI

ASKER

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.

SolutionsTI

ASKER

Requesting attention to give points to peter57r. My error. I am sorry.