Access ObjectID

[Bruce M]

I get an error message stating "ObjectID" in not an index in this table. Is
there a way to repair or overcome this so can access my data?

 

[Tom Wickerath]

Hi Bruce,

I've heard of 'AOIndex' is not an index in this table, but I've never
encountered 'ObjectID' is not an index in this table. See symptom #20 in
Access MVP Tony Toews' collection of corruption symptoms, here:

http://www.granite.ab.ca/access/corruption/symptoms.htm

You might try one of these methods, to see if you have any luck:

How to recover data from a damaged database table or a corrupted
database table in Access 2000, Access 2002 or Access 2003
http://support.microsoft.com/?id=247771

How to Recover Data from a Corrupted Table by Using the DAO Method
http://support.microsoft.com/?id=815280

As far as preventing corruption in the future, see these two articles:

Preventing Corruption (Allen Browne)
http://allenbrowne.com/ser-25.html

Corrupt Microsoft Access MDBs FAQ (Tony Toews)
http://www.granite.ab.ca/access/corruptmdbs.htm


Good Luck,

Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Tony Toews [MVP]]

I get an error message stating "ObjectID" in not an index in this table. Is
there a way to repair or overcome this so can access my data?

I don't recall ever seeing this specific message and a Google Groups
shows no hits. What version of Access? Are you fully patched?

Tom has already posted relevant links.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[a a r o n . k e m p f]

sounds to me like a sql server thing.

select * from sysindexes
where id = object_id('employees')

I think that is the correct syntax.

HTH

-Aaron

 

[Alan]

I get an error message stating "ObjectID" in not an index in this table. Is
there a way to repair or overcome this so canaccessmy data?

Hi,

If you can't handle the recovery of your database by yourself, I think
you can try a utility called Advanced Access Repair to repair your
Access MDB file (althoug not free). It works rather well for my
corrupt Access MDB files. Its web address is http://www.datanumen.com/aar/
Hope this helps.

Alan

 

[Tom Wickerath]

Alan,

You are a case study in how to piss off influential people (Access MVPs) to
make sure that they *NEVER* recommend your company's services. I suppose it's
only a coincidence that your e-mail address includes "@datanumen.net", and
the URL you just included has "datanumen.com". That's call spamming the
newsgroups. Personally, I'd recommend the services of Peter Miller (PK
Solutions) any day over what your company offers. You are a shady character,
my friend.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Douglas J. Steele]

Agreed.