problem opening access table

[George Applegate]

I have an access database in 2007 format. I have two Pc's with access
2007. the file extension is accdb. On the one PC the file opens just
fine. On the other PC I get an "index not found" error. I don't
understand why one works and one doesn't. Any ideas? I think I have
seen this error before but not recently.

Both Pc's were full installs of office 2007 and as I said, I can open
it just fine on the one, but not the other.

Thanks,
ga

George Applegate
(e-mail address removed)

 

[Jerry Whittle]

Are both of these PCs hitting the same database file that is out on a network
drive or copies of the same database?

 

[George Applegate]

Jerry,

YES, the database file is on a network drive. actually, The accdb
file is FILENAME.accdb. Somehow this file is tied to FILENAME.dbf
file and possibly FILENAME.cdx file...

But both PC's are running windows xp service pack 3. Both have
security to the file - no issues there. Both are using office 2007
(access 2007).

One Pc opens the file just fine, the other bombs with the error every
time. I saw something about a registry entry for Borland database vs
ISAM and tried that but didn't do anything. Then I also found
something in google about maybe this if VFP (visual foxpro?). I just
have no idea what is different so that one PC opens it up just fine
and one doesn't.

I even exported the file to a 2002-2003 access database (mdb). Okay,
the one PC will still not open it. However, other pc's in my
organization who are still running office 2003 can open this mdb file
with access 2003. So it almost has to be some setting on the PC
itself...But WHAT?????

Any help is much appreciated.

Thanks,
ga

Are both of these PCs hitting the same database file that is out on a network
drive or copies of the same database?

George Applegate
(e-mail address removed)

 

[Jerry Whittle]

Unfortunately you may need to wipe the hard drive of the problem PC and
reinstall Windows, Office, and everything else. If that PC is due for
replacement, that might be the best option.

 

[kirschbaum-karzbon]

Unfortunately you may need to wipe the hard drive of the problem PC and
reinstall Windows, Office, and everything else. If that PC is due for
replacement, that might be the best option.