Solved

MS Access 2010 Open form Error

Posted on 2012-03-26
6
438 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
  • 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 57

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 57
ID: 37765357
Also, assuming you've tried a compact and repair, althought that probably won't do anything in this case.

Jim.
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

707 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now