Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Access 2003 database doesn't work in access 2010

Posted on 2013-01-10
2
Medium Priority
?
285 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
[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 Comments
 
LVL 18

Accepted Solution

by:
xtermie earned 2000 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

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

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

How to Win a Jar of Candy Corn: A Scientific Approach! I love mathematics. If you love mathematics also, you may enjoy this tip on how to use math to win your own jar of candy corn and to impress your friends. As I said, I love math, but I gu…
Lithium-ion batteries area cornerstone of today's portable electronic devices, and even though they are relied upon heavily, their chemistry and origin are not of common knowledge. This article is about a device on which every smartphone, laptop, an…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

688 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