Can't Open Database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JamesJ - 28 Jan 2004 16:44 GMT

Just got a new computer. I had the builder save my existing hard drive which
has
Access2000 and my db app on it. I installed a full version of Access 2003 on
the
NEW hard drive and now I am unable to open my db. I converted the front and
back
end to 2002/2003 format.
At this time when I try to open it I get an error 13 Type mismatch at:
Set RecClone = Me.RecordsetClone()

The only way at this time I'm able to do anything at all with my db is to
bypass
the Autoexec macro.
Also the Recently used list in the Options General tab is disabled.

Any and all help will be appreciated.

Thanks,
James

Reply to this Message

JamesJ - 28 Jan 2004 19:49 GMT

One more thing. I'm also getting an error message at:

Private Sub Form_Open(Cancel As Integer)

Me.RecordSource = Forms!frmDataAccess.RecordSource

Dim rs As Recordset
If Not IsNull(Me.OpenArgs) Then
Set rs = Me.RecordsetClone
rs.FindFirst "[ReminderID]=" & Me.OpenArgs
If rs.NoMatch Then

Else
Me.Bookmark = rs.Bookmark

End If
End If

End Sub

I double click or hit enter to open a form to the current record on the
calling form.

Error Message:

Compile Error
Method or data member not found.

I went into the Object Browser but had no idea what to look for.

Thanks again,
James

> Just got a new computer. I had the builder save my existing hard drive which
> has
[quoted text clipped - 15 lines]
> Thanks,
> James

Reply to this Message

John Nurick - 29 Jan 2004 06:34 GMT

Hi James,

This sounds like a common problem with references. See
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html
for details and how to fix it.

>One more thing. I'm also getting an error message at:
>
[quoted text clipped - 51 lines]
>> Thanks,
>> James

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message