NEED SERIOUS HELP - WORK ACCES DB DIED.

[Guest]

hello - i am in charge of many mdbs here at work.
one db has been giving me problems.
when i tried to open it, the repair tool came up. i ran it.

now - when it was done - an error of 3015 stating the indexes are incorrect.
i cannot access ANY of the tables or queries without error.

the info is there but i cannot get into the db to fix. can you help? my
job relies on it. thanks so much.

 

[Guest]

really need help guys...........

 

[Ken Snell [MVP]]

Create a new database and import all the objects from the "bad" database
into the new one.

 

[Immanuel Sibero]

Hi
Sounds like corruptions.
Make a backup copy. Create a new mdb. See if you can import all objects to
the new mdb.

Tell us a little more about your environment.
- What version of Access? What OS? What Network OS?
- Are you up on Service Packs
- On a network? Are you using Front End / Back End?

Immanuel Sibero

 

[Guest]

thanks immanuel - i really appriciate it.
we are using access97 and are in windows nt os.
let me try to make bu copy. thanks man!
we are using back end too.

 

[Guest]

thanks ken tried everything and not working. def corrupted w/o return.

 

[Immanuel Sibero]

From the new mdb, can you link to the tables? Any of the tables?

Immanuel Sibero

 

[Guest]

nothing at all. totally locked.

From the new mdb, can you link to the tables? Any of the tables?

Immanuel Sibero

 

[Ken Snell [MVP]]

Then your only hope would be "getting copy of a backup" of the file, or
perhaps a commercial service could extract some data for you (costs money
and may not get everything).

 

[Joan Wild]

nothing at all. totally locked.

Try compacting your database using Jetcomp, available at
http://support.microsoft.com/?id=273956