Solved

Form in Access 2000 and 2002/2003 formats not found in Access 2007

Posted on 2011-03-18
7
246 Views
Last Modified: 2012-05-11
I have a database which was created in Access 2000 format and is still being maintained in this format.
I have made numerous little changes to it over the past few months.
It is used in higher versions of Access up to 2010.
I have now made a small change to a form and although it still works perfectly in Access 2000 and 2002/3 I get a message from Access 2007 that it does not find the form although the name of the form is still visible, but does not open.
I also get a message that a module is missing.
There is security enabled on the file.
Any pointers please?
.  Message received although file name is there
0
Comment
Question by:Fritz Paul
  • 4
  • 2
7 Comments
 
LVL 13

Expert Comment

by:lucas911
Comment Utility
1.  Compact and repair
2.  Press ALT F11 to bring up the code, then click debug and compile your database.  If the compile fails it will tell you where the error is.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
Comment Utility
Or, create a blank new Access 2000 format DB in Access 2007 and import all the objects...
0
 

Author Comment

by:Fritz Paul
Comment Utility
Sorry for the delayed response.
I really appreciate the prompt responses.
Although I found the responses helpfull, it did not solve my problem. I might have to phrase it differently.
I am still looking for the reason for my problem, but I hope to find that by tomorrow.
In the mean time I could import the unaltered form from an older backup, so the system is running,
I will give feedback by tomorrow.
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
Comment Utility
Are you looking for the reason, or are you looking for a solution... or both...

The reason:
 We cant know for sure unless you post a sample of the DB.
But in a nutshell, it sounds like the db is corrupting

The solution:
"import the unaltered form from an older backup'... as you stated
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
Comment Utility
0
 

Author Closing Comment

by:Fritz Paul
Comment Utility
Nothing else that I tried helped. My system is running again.
Thanks for all the efforts.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
Comment Utility
ok
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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…

728 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

13 Experts available now in Live!

Get 1:1 Help Now