Switchboard Error

[Michael Beckinsale]

Hi All,

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

 

[Allen Browne]

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.