compact and repair not working

[NAS]

There is a database on our shared server that has a missing reference and
wont open. The problem only happens on 2 machines. I have tried going into
the references and unchecking the missing reference but now I get an error
saying the database is corrupted and that I need to run a compact and repair.
This would be simple except for the fact that when I try to run a compact and
repair I get the same error message, that its corrupted and I need to run the
C&R. How am I supposed to run the C&R if I keep getting this error message,
with the only option to click OK 50 times until it goes away, only to come
back when I click on anything else? I am using Access 2003 on Windows XP.
Sorry if this is confusing to anyone....

 

[Douglas J. Steele]

Try creating a new, empty database and importing everything from the corrupt
database into it.

You might end up having to import the objects one-by-one until you find
whatever's causing the corruption.

 

[Jerry Whittle]

Doug's suggestion is certainly a good one.

Another idea is the free JetComp utility from Microsoft. It does a much
better job of doing a compact and repair.

After that, how good is your most recent backup?

 

[NAS]

I brought in our backup which was from a different machine and from the end
of Friday and was able to fix it. I didnt get a chance to try your method
since I got it fixed before that, but I will certainly remember to try that
next time I face the issue. Thank you all for youe help.

 

[NAS]

I brought in our backup which was from a different machine and from the end
of Friday and was able to fix it. I didnt get a chance to try your method
since I got it fixed before that, but I will certainly remember to try that
next time I face the issue. Thank you all for youe help.

 

[Gina Whipp]

NAS,

STOP... Your database is, in fact, in trouble. You need to follow Douglas'
or Jerry's suggestion before you have a much more serious problem. You also
didn't mention... is your database split?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Tony Toews [MVP]]

There is a database on our shared server that has a missing reference and
wont open. The problem only happens on 2 machines.

This sounds like your users are sharing the database with the queries,
forms, reports, macros and VBA code. Not a good idea.

You want to split the MDB into a Front End MDB containing the queries,
forms, reports, macros and modules with just the tables and
relationships in the Back End MDB. The FE is copied to each network
users computer. The FE MDB is linked to the tables in the back end
MDB which resides on a server. You make updates to the FE MDB and
distribute them to the users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
free Auto FE Updater utilities at http://www.autofeupdater.com/ to
make this relatively painless.. The utility also supports Terminal
Server/Citrix quite nicely.

I have tried going into
the references and unchecking the missing reference

What was the missing reference? We can likely give you some
suggestions on how to correct the missing reference problem for those
two PCs.

Tony