MS Access 2010 Open form Error

Hi.  I am hoping someone out there can help me with a problem i am experiencing with a MS Access 2010 adp file.  When I open it, it up with the following error message:

<adp name> can't open the form <form name>
It contains data that <adp name> doesn't recognize
Re-create the form or, if you maintain backup copies of your database, retrieve a copy of the form

When i revert to an older version of the adp it works but the next time i open it (regardless of the fact that no changes were made to the adp) the error message reappears.

The adp file links to a MS SQL-Server database.

Thanks.
AUSTALAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor President / OwnerCommented:
Sounds like the form is corrupt.

I'd create a new ADP, import everything into it and see if that cleans it up.  If not, then you'll need to use stronger measures such as saveastext/loadastext and /decompile to try and clean it up.

Jim.
0
 
mbizupCommented:
Have you tried reverting to a much older backup, or recreating the form as new?
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Also, assuming you've tried a compact and repair, althought that probably won't do anything in this case.

Jim.
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
AUSTALAuthor Commented:
Hi.  Thanks for alll the suggestions.  I will try to recreate the form first and if that fails, I'll create a new ADP.  I'll update this question as I go along.
0
 
AUSTALAuthor Commented:
Unfortunately recreating the form and doing a compact and repair did not fix the problem.
0
 
AUSTALAuthor Commented:
Creating a new adp and then importing all the relevant items into it seems to have fixed the issue.  Thanks
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.