help! 2007 corruption & references

[TonyT]

Hello,

I'm having endless corruption issues with 2007, at least twice a day I'm
having to do the multi compact & repair / decompile routine, usually having
to go as far as creating a new accdb and importing all the objects again. It
seems to corrupt less quickly if I also change the name of the newly created
db although that might just be in my mind.

One thing I'm wondering might be the cause is the fact that when I dim a
recordset as a DAO.Recordset I have the choice of Recordset / Recordset2 with
the intelliprompt, but only recordset2 works, I get an error if I use just
DAO.Recordset - 'method or data member not found' on compile.

Previously in a2k I had a similar problem whereby I couldn't use any
recordset in dimming and had to leave all recordsets as Dim rcd

So I'm thinking I may a have a corrupted reference on the pc somewhere. In
the vb references I only have;
Visual Basic for Apps
Microsoft Access 12.0 Object Library
Microsoft Office 12.0 Access database engine Object Library

with no Missing references at all.

So where is the second inoperable Recordset coming from?

How do I go about 'cleaning up' the references and un-registering any I may
not need. Otherwise I'll have to think about a completely fresh installation
of Windows, as I reckon this is the cause of my corruption.

I someone could help or point me in the right direction please.

 

[Damon Heron]

Hiow about adding a reference to
Microsoft DAO 3.6 Object Library
??

Damon

 

[TonyT]

As 2007 uses 'Microsoft Office 12.0 Access database engine Object Library'
instead, (ACEDAO.DLL) in fact it won't even allow DAO 3.6 to be selected on
my pc.

 

[Douglas J. Steele]

I believe Access 2007 uses 'Microsoft Office 12.0 Access database engine
Object Library' when the file is in the new ACCDB format, and DAO 3.6 when
it's in the heritage MDB format.

 

[TonyT]

Any idea if there could be remenants of a corrupt dao reference giving me the
dual recordsets? As from what I can find out, there should only be one
Recordset available with the references I have currently.

 

[Douglas J. Steele]

Sorry, I've never heard of a problem like this with a Recordset2 object. I'm
afraid I have no suggestions.

 

[TonyT]

I was afraid you were going to say that <g>

I'll wait another day to see if I get any other responses, else I'm up for
the hdd format & windows reinstall.