Your database is corrupt. First make a copy of the file. Second, import the
objects, 1 at a time, into a new empty database. Compile your new work. If
you have further trouble Download a copy of JetComp.exe:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956
Also have a look at the Microsoft KB article:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137
Then have a look at Tony Toews' Access Corruption FAQ at:
http://www.granite.ab.ca/access/corruptmdbs.htm
for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.
Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:
http://www.pksolutions.com
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
Sam Cunningham said:
I have just recently created a database in Access and right before
completing it I began to get an error that states MSysacess obects table
already exists. I t doesnt stop me from opening editing or entering data.
It only happens on close. Any ideas on what this may be? Any help would be
appreciated,
