We recently upgraded our Microsoft Access 2003 to 2007. We have been using the database without problem. But when we open the file using Access 2007, it gives us the following error message:
The form name "products" is misspelled or refer to a form that doesn't exist".
If the invalid form name is a macro, an Action Failed dialog box will display the macro name and the macro's arguments after you click OK. Open the Macro windows, and enter the correct form name.
We are lost as we have no problem using the same database using Access 2003. Can anyone help?
Thanks.
If the form "products" really exists, then your office 2007 security settings are not allowing to load macros. Try the following settings:-
Office 2007 has some security settings disabled by default to prevent any harm to your system.
go to trustcenter settings(click the office button at the top left of the office 2007 screen then click Access options, then select Trustcenter, then click trustcenter settings.)
In trustcenter settings, select message bar then select "Show the message bar in all applications when content is blocked" radio button.
Then from macro settings ,make sure to select "Disable all macros with notification" . Click ok twice to close the settings windows and try opening the file again.
Good Luck
Try to open the file with shift button pressed. If it opens correctly there must be some macros loading at the startup.
Go to Trustcenter settings, change message bar settings to "show me the message bar...."
and Macro settings to " disable all macros with notifications".
try again by restarting access.
Try opening the file by press & holding shift key. if it opens successfully then there must some macros being loaded with the file. enable message bar settings to view the notifications from the trustcenter settings and enable "Disable macros with notifications" from macro settings.
when u open the file again you will find a message bar at the top that some content has been blocked, if you allow it, it should open as desired.
Best of Luck
×
SOURCE: Problem opening Access Database-upgrade from Access 2003 to 2007
It seems that you have your Database(.mdb) file is created in Office 2003.... thats why you are unable to open it in 2007.... I faced the same problem.... then I came back to 2003 in order to use our database......
383 views
Usually answered in minutes!
We got the error upon opening of the database.
Do you get the error upon open of the database, or when you make a selection to "products" in the "splash form, and then the error appears?
×