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?