'Id' is not an index in this table

  • Thread starter Thread starter 2klbofun
  • Start date Start date
2

2klbofun

I get the following error:

"'Id' is not an index in this table"

when opening an Access 2007 file that I have been working on. This file
only contains one VBA macro (with a few functions/subs). The data is in two
other .accdb files.

I have tried the Compact/Repair, but it errors out. I also tried the
Jetcompact.exe utility, but it does not work for this version.

If I could simply extract the macro text, I could paste it into another file.
 
Yes I do have a backup, but there was a fair amount of work lost.

I guess I just need to backup more often. . .

I also tried opening the raw .accdb file in a text editor, but I guess there
is some type of compiling going on behind the scenes, because pulling out the
VBA script would be a nightmare.
 
Back
Top