CODEWITHSUNDEEP
ms-accessvba
Dinkheller
Dinkheller

Reputation: 5054

Recover VBA Code from Access DB File

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?

Upvotes: 0

Views: 9236

Answers (3)

Fionnuala
Fionnuala

Reputation: 91316

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

Upvotes: 1

i_saw_drones
i_saw_drones

Reputation: 3506

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.

Upvotes: 1

mr_plum
mr_plum

Reputation: 2437

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

Upvotes: 0

Related Questions