Solved

MS Access 2010 Open form Error

Posted on 2012-03-26
6
443 Views
Last Modified: 2012-03-27
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.
0
Comment
Question by:AUSTAL
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 61

Expert Comment

by:mbizup
ID: 37765016
Have you tried reverting to a much older backup, or recreating the form as new?
0
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 370 total points
ID: 37765351
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
 
LVL 58
ID: 37765357
Also, assuming you've tried a compact and repair, althought that probably won't do anything in this case.

Jim.
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 

Author Comment

by:AUSTAL
ID: 37769450
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
 

Author Comment

by:AUSTAL
ID: 37769577
Unfortunately recreating the form and doing a compact and repair did not fix the problem.
0
 

Author Closing Comment

by:AUSTAL
ID: 37770205
Creating a new adp and then importing all the relevant items into it seems to have fixed the issue.  Thanks
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question