'Id' is not an index in this table

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.
 
C

Chris O'C via AccessMonster.com

Vba and macros aren't the same thing in Access dbs. A macro is a db object
that has macro commands and a module is a db object that contains vba code,
commonly organized in procedures with parameters and error handling.

You can't use the Jetcomp utility on an ACE db because it's the wrong format.
You can tell it's an ACE format when the file extension is accdb, accde,
accdr or accdt.

Your db file sounds like it's corrupted. Do you have a backup?

Chris
Microsoft MVP
 
2

2klbofun

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.
 
C

Chris O'C via AccessMonster.com

You can't extract the vba code from the binary file with a text or hex editor.
Frequent backups are important to avoid lost work.

Chris
Microsoft MVP
 
Top