Invalid database object reference (1 Viewer)

Jacob Mathai · Dec 29, 2008

I use ACCESS 2007 with Windows XP. I have a big data base (in terms of size). When I compact the data base, I get a message "Invalid data base object reference." When I click on Help key, I see error # 3276. I am not hitting the 2GB limit. Data base is .MDB and uses 2000 file format.

I did debug/compile and I am still getting this error message when I compact the data base. This data base is run by windows scheduler at night. This error message is causing a real problem.

My processing includes linking to SQL server and copying data tables from SQL server into MS ACCESS.

Any help will be appreciated.

RuralGuy · Dec 29, 2008

Have you tried importing everything into a new mdb and then Compact and Repair?

Jacob Mathai · Dec 30, 2008

RuralGuy said:
Have you tried importing everything into a new mdb and then Compact and Repair?

I did it. I am still getting the message.

Thanks for your reply.

philosofe · Dec 30, 2008

Hi Jacob,

We've had a similar problem here with a couple of dbs, where doing the earlier mentioned sollutions didn't work.

What solved the issue for us was creating a new db, importing table definitions only, then launching an append query (I don't know exactly why this worked, but perhaps a piece of corrupt data that the compact / repair didn't 'detect'?)

Jacob Mathai · Dec 30, 2008

Thanks. I will try that.

Jacob Mathai · Jan 1, 2009

This is my observation.

When I manually do 'compact & repair', it works without problem.

It is the 'compact on close' what is giving me problem. When I close the data base, this error shows up (not all the time, but most of the time).

philosofe · Jan 3, 2009

Ok, so the MS KB has got a description of the error at

http://msdn.microsoft.com/en-us/library/bb223144.aspx

The Database object specified is not the result of the OpenDatabase method, or it has been modified and is no longer valid.

According to this, it's a DAO-realated error. Is there any open form that's got code set to run OnClose, referencing a linked source?

Jacob Mathai · Jan 13, 2009

I think my data base is ok now. I have run it 10 times (Repair & compact) without the error message mentioned in this thread. I am 95% sure that the problem is solved.

My problem may have been caused by not installing MS Office 2007 correctly.

I opened an ACCESS data base.

Clicked on Microsoft button (top/left)

Access Options

Resources

Run Microsoft Office diagnostics.

System told me there was some problem and it reapaired it.

Looks like that was the problem. I thought I share this info with all those who tried to help me.

I am hoping the problem will not show up again.

P.S. My data base size is 1.8 GB prior to compacting. When compacted, it goes to 900 MB. So, every time I run this job the data base must be compacted. There is a scheduled nightly run every night using Windows Scheduler. This is a critical application for us.

csnodgrass · Jan 8, 2019

I am late to this answer, but in my case the error was caused by object naming-having the same name for a form and table. So, if anyone else has this issue, review all the object names.
Cheers

The_Doc_Man · Jan 8, 2019

A good observation! Thanks for posting the tip, csnodgrass! And yes, Access doesn't like it when you give it confusing names.

Bombastic · Oct 1, 2019

Check if you are using a 'pass-through' query inside your 'normal' query. It appears that pass through queries can not be read from the accdb file.

My fix was to convert the pass through query back to a normal query.

Invalid database object reference (1 Viewer)

Jacob Mathai

Registered User.

RuralGuy

AWF VIP

Jacob Mathai

Registered User.

philosofe

Registered User.

Jacob Mathai

Registered User.

Jacob Mathai

Registered User.

philosofe

Registered User.

Jacob Mathai

Registered User.

csnodgrass

New member

The_Doc_Man

Immoderate Moderator

Bombastic

New member

Similar threads

Users who are viewing this thread