Hi, I would appreciate any help or

[BeckahC]

Hi, I would appreciate any help or suggestions.

Iam usually a SQL programmer but I have recently been handed a database that is on one of our servers, it's an Access 97 database and I am not too up to date on Access. One of the tables, when opened continuously throws this error at you:

"Not a Valid Bookmark."

Then you just click on OK until either you get tired and ask Task Manager to close the program, or if you keep going, Dr.Watson steps in with an Application error and closes Access for you. (This is an NT server)

I tried repairing the database, but this gives me an error regarding the indexes. Also, I made a copy of the database and tried deleting the table and then repairing the database and it threw the same error at me as before I deleted the table.

This is a database that is used heavily by across the country and I am hoping I will not have to scrap it and start from scratch. If anyone can help or offer any kind of suggestions, I would appreciate it.

Thanks,
Rebecca Rebecca Cashman
rcashman@leviton.com

 

[Niv3k]

Can you import the data into another Access database? If so, import the data into a second db, and link the tables.

Good luck,Kevin

 

[BeckahC]

Thank you Kevin,

I haven't tried exporting it, I will try this. What I really need my end result to be is getting the database repaired and even after making a copy of the database and deleting the whole table the repair database function would not work.

I will let you know if exporting the table works.

Thanks,
Rebecca Rebecca Cashman
rcashman@leviton.com

 

[tlbroadbent]

You might want to install the Jetcomp utility. Sometimes, it can repair databases that Access can't. It is part of Jet 3.5 SP3.

Download here:

http://support.microsoft.com/support/kb/articles/Q172/7/33.ASP

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.