[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

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

Posted on 2011-03-18
7
Medium Priority
?
256 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
[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
  • 4
  • 2
7 Comments
 
LVL 13

Expert Comment

by:Lucas
ID: 35166386
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
ID: 35167520
Or, create a blank new Access 2000 format DB in Access 2007 and import all the objects...
0
 

Author Comment

by:Fritz Paul
ID: 35193546
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
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 1000 total points
ID: 35193936
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
ID: 35195269
0
 

Author Closing Comment

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

Expert Comment

by:Jeffrey Coachman
ID: 35223827
ok
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

656 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