Database repair breaks RecordClone

[Jim Shaw]

My database was running fine for several months. My logic
calls subroutines that build recordsetClones to navigate
around in. Previous database repair & Compress runs
seemed to work ok.

Now, after a repair & compress run, all references to
members of a recordsetClone (e.g.; myRecClone.EOF )result
in a compile time error that the referenced member is not
in the recordsetClone.

I did recently download the latest Office patches, but I
don't have sufficient data to point at them as the cause
of my problem.

Anybody got any ideas what might be going on.

Thanks

-Jim

 

[SteveS]

If you are using Access 2K or XP, check to make sure a
reference is set to 'Microsoft DAO 3.6 Object Library' and
does not show 'Missing'.

Steve

 

[Jim Shaw]

Can't do that. I'm running Access XP. When I try to open
VBA IDE it crashes and wants to repair database. So I
can't see the references menu iitem. This problem appeard
after I "Repaired" the db. So...

I created a new db and exported all my application objects
into it (Forms, Querys, Tables, Macros, Modules). The new
db came up ok, but with two proboems:
1. Switchboard doesn't start unless I open it thru forms.
2. The member not found problem still exists.

Then I discovered a problem with the declaration of my
subroutine:

I had :
private sub mySub(myRecs as recordset)
I should have had:
private sub mySub(myRecs as DAO.recordset)
as the passed record set was a DAO recordset.

That fixed the problem of the member not found. I'd be
surprised if that caused Access to crash, but it is
related to your suggestion.

I'm still stroking my beard on this one....

Thanks
Jim

 

[JIm Shaw]

Access XP
Found a back door way in to VBA IDE via
(Form=>properties=>events=>[Onevent]=>code

Microsoft DAO 3.6 Object was set.
-Jim

 

[SteveS]

1. Switchboard doesn't start unless I open it thru forms.

I don't have XP, but I think it is still under Tools | Startup where you
can set the form to be displayed when the dB is opened.
It is the combo box labeled "Display Form/Page:"

Steve