Solved

Access Database damaged

Posted on 2013-05-10
3
314 Views
Last Modified: 2013-05-23
Hi,
  I am an MS Access programmer and I have a weired situation.
  I can the main menu, but when I click the buttons to open other forms, no response. I can open the forms manually from the FORM section in ACCESS, but again the buttons that I have added to the forms are there but does not do anything when you click them. Strange enough, default Access default controls (such as Drop-down menu, record navigation buttons at the bottom of the form, Tabs) do still work
   I opened one form in design view and opened "On Click  Event Procedure" and found no code/VB associated with each button.

  Fortunately I do have old-dated database files that I can import the forms from, but I like to know :
(1) what just happened and
(2) If it is a good idea to just import forms from a good previous database and continue to use this datbase or open the most recent database file and import tables/queries and etc from the damaged database. Obviously this involves more work.

Thanks.
0
Comment
Question by:sglee
  • 2
3 Comments
 
LVL 28

Accepted Solution

by:
burrcm earned 204 total points
ID: 39157757
Access corruption is the name of the game. It happens routinely when developing. Take a copy daily, repair often. Go to an earlier known good copy and import the required items. The current copy is not worth saving.

Chris B
0
 
LVL 28

Assisted Solution

by:burrcm
burrcm earned 204 total points
ID: 39157758
An issue of which you should be aware is the name autocorrect option, which leads to corruption often. Disable it if you have not already -

http://allenbrowne.com/bug-03.html

Chris B
0
 
LVL 57

Assisted Solution

by:Jim Dettman (Microsoft MVP/ EE MVE)
Jim Dettman (Microsoft MVP/ EE MVE) earned 101 total points
ID: 39158017
<<   I opened one form in design view and opened "On Click  Event Procedure" and found no code/VB associated with each button.>>

 The VBA project is corrupt.  You can try getting it to work using the /Decompile switch at startup.

<<(1) what just happened and>>

 Make sure your up to date with service packs.  I disagree with Chris that "It happens routinely when developing."

  I think I've only had corruption at most a half dozen times in nineteen years of Access development (although I must say, I never use new versions until at least service pack 1).

<<2) If it is a good idea to just import forms from a good previous database and continue to use this datbase or open the most recent database file and import tables/queries and etc from the damaged database. Obviously this involves more work.>>

 I would try /decompile first.  If that doesn't work, then it's a toss up which way to go.  Sounds like the older DB would be the least amount of work.  At least you get some code that way and if you have new objects, you could import those from the current DB.

 By the way, here's some detail on the /Decompile switch:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_2043-Decompile-What-it-is-what-it-does-and-how-to-use-it.html

Jim.
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

856 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