Cannot open .adp file with Access 2007

We recently upgraded to Office 2007. Now when attempting to open an Access .adp file (Access 2002-2003 format) that is linked to SQL data, I receive the error "There isn't enough memory to perform this operation. Close unneeded programs and try operation again." Does anyone know how to resolve it this error?
LVL 2
M3hcSSAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
divtConnect With a Mentor Commented:
Here is a workaround:

1. Create a new ADP with Access 2007.
2. Configure SQL server connection
3. Import forms/reports/codes/etc. from your old ADP.

Hope this helps.
0
 
M3hcSSAuthor Commented:
Thanks for the suggestion divt. I was actually able to get the file to open by tweaking it in Access 2003. It appeared that there was no Switchboard or form set for the database Startup to default to. After I pointed Startup in Access 2003 to a form in the database, the file opened successfully with Access 2007. Problem solved.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.