Prob when I use 'Analyse'

  • Thread starter Thread starter KRISH
  • Start date Start date
K

KRISH

Hi! everybody,

When I use 'analyse' to my database and
selected 'Relationship' I am getting the following error
message:

Item not found in this collection.

if all objects selected. then error message box are:

(1) Subscript out of range
(2) Invalid procedure call or argument

The above may be the reason which unables me to split my
database.

Kindly help how to solve the proble.

Thanks for any help.

Krish
 
It sound like one or more indexes is corrupt. First, always work on a copy
of the database. Working on the original may make it impossible for a repair
service to fix it.

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
 
Back
Top