Recover VBA Code from Access DB File

Question

all of a sudden my ACCESS 2010 VBA Code cannot be opened any longer. I receive the error, that ID is no longe an Index of the table.

Pressing ALT - F11 does not open VB any longer.

Any ideas how I can recover my VBA Code?

When do you receive the error? When the db is first opened? If so, you could try opening the file while holding down the [Shift] key. This will prevent any startup forms or Autoexec macros from running, which may allow you to get at your code before getting the error message. — mwolfe02
– mwolfe02, Commented Nov 9, 2011 at 16:28
I can open the DB (an error poping up, but I can open it) Then, when I douple click on a module, the error I described pops up and finally nothing happens. — Dinkheller
– Dinkheller, Commented Nov 9, 2011 at 17:14

i_saw_drones · Accepted Answer · 2011-11-09 16:23:10Z

1

Please try some of the ideas here (although it depends on the database format, AC97/2000 etc.): http://allenbrowne.com/ser-47.html. Perhaps if you can repair the database enough so that whilst the structure may be truncated you could perhaps still get at your VBA code.

answered Nov 9, 2011 at 16:23

i_saw_drones

3,5061 gold badge33 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

mwolfe02 Over a year ago

@Proto Bassi: Which of the methods listed on that website did you actually try? It is a pretty exhaustive list (re-import objects into new db, decompile, SaveAsText/LoadFromText, etc.).

Dinkheller Over a year ago

I tried: Build in repair Import Delete References Deleted all Indexes in the tables Save as Text

mwolfe02 Over a year ago

How did you delete the references if you cannot open the VBA IDE? Or am I missing something?

Dinkheller Over a year ago

I can open the DatabaseTools. From there I can delete the references between the tables and get rid of any Primary keys

Fionnuala · Accepted Answer · 2011-12-05 13:30:12Z

1

I have found that Decompile followed by compact and repair will often fix this problem.

answered Dec 5, 2011 at 13:30

Fionnuala

91.4k7 gold badges121 silver badges155 bronze badges

Comments

mr_plum · Accepted Answer · 2011-11-09 16:21:30Z

0

Enable the Developer Tab per http://msdn.microsoft.com/en-us/library/bb608625.aspx and click the Visual Basic button.

answered Nov 9, 2011 at 16:21

mr_plum

2,4372 gold badges19 silver badges31 bronze badges

4 Comments

Dinkheller Over a year ago

Developer Tab is enabled and the VB Button does the samme as described above.

Dinkheller Over a year ago

In ACCESS there is nothing like a developer tab. But I know where to press to get to VB.

mr_plum Over a year ago

So you clicked the VB button under Database Tools and nothing happens? Can you test the DB on another machine to determine if it's a problem with your OS?

Dinkheller Over a year ago

I made a backup two days ago and that one works without a problem. But I would loose two days.

Collectives™ on Stack Overflow

Recover VBA Code from Access DB File

3 Answers 3

4 Comments

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related