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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.