Both the ADO library and the DAO library have a Recordset object. You need
to specify which you want when you declare your variable, i.e.:
Dim rst As DAO.Recordset
Alternatively, deselect the ActiveX Data Object library if you do not need
it.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Michael Beckinsale" <(E-Mail Removed)> wrote in message
news:eFfuIS%(E-Mail Removed)...
>
> Help urgently required please.
>
> Using Access 97 and Windows 98
>
> I was hoping to put the finishing touches on my project and have come
across
> a problem with the switchboard.
>
> Using the Switchboard manager l created a switchboard with the various
forms
> l required.
>
> When l try to open the switchboard i get an 'Error 13' message and when l
> hit the debug key the following line of code
> is highlighted in yellow
>
> SET rst = dbs.OpenRecordset (strSQL)
>
> I assume that this code is generated by the use of the Switchboard manager
> as l certainly haven't written it.
>
> I think that the problem may be with References and these are the ones l
> have ticked.
>
> Visual Basic for Applications
> Microsoft Access 8.0 Object Library
> OLE Automation
> Microsoft Active X Data Object 2.1 Library
> Microsoft DAO 3.51 Object Library
>
> All help / suggestions gratefully received.
>
> Regards
>
> Michael Beckinsale
Similar Threads
