Solved

Access 2003 database doesn't work in access 2010

Posted on 2013-01-10
2
276 Views
Last Modified: 2013-01-10
I wrote a simple "Query By Form" database the queries multiple fields of one table using all or partial information entered into a text box.  This database was wittten using Access 2003.

Our organization recently updated from Windows X/P to Windows 7 and Office 2010 suite.  Trying to operate the old Access 2003 database in 2010 has resulted in multiple choke points, as follows:

"This file might not be safe"

A dialog box appears once the search criteria are entered, that requests the search parameter be entered again, then the query performs as usual.

When the user clicks on the "exit" button, a message appears that the event setting is not supported by the object class, and the user has to "X" out of the application.

Is there a one-size-fits-all fix for converting form Access 2003-2010, or do we have to address these issues on a case-by-case basis?

Please advise
0
Comment
Question by:aasikolo
2 Comments
 
LVL 17

Accepted Solution

by:
xtermie earned 500 total points
ID: 38762902
Check your security settings it seems that the warning message is about Macros. Macros are bits of programming within any document, excel or access file that hold VB coding. The warning is because Macros can hold viruses which, when the macro is invoked, can spread into the computer.

In Tools > Options, Security tab look for the Macro Security button and make your choices of macro security there (set to Low and see if this still pops up). However, this may not be a very safe way.

If those choices are not available, then speak to the IT people as they may have disabled the options.
0
 

Author Closing Comment

by:aasikolo
ID: 38763021
I'll pass ths along ot hte IT folks, There isn't even a security tab on my version.

Thank you
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Manufacturing a NPK fertlizer 7 23
Sample Space 12 38
Independent Events 4 50
Homework Help 5 48
Introduction On a scale of 1 to 10, how would you rate our Product? Many of us have answered that question time and time again. But only a few of us have had the pleasure of receiving a stack of the filled out surveys and being asked to do somethi…
Foreword (May 2015) This web page has appeared at Google.  It's definitely worth considering! https://www.google.com/about/careers/students/guide-to-technical-development.html How to Know You are Making a Difference at EE In August, 2013, one …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
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…

708 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now