switchboard error

  • Thread starter Thread starter Michael S. Montoya
  • Start date Start date
M

Michael S. Montoya

I have a computer that gives errors when opening a switchboard (the ones
that are created with the 'Switchbaord Wizard'. I get this error even if
the switchboard is created on that computer.

If I go into the code and change the recordset to DAO and use
Currentdb.openrecordset it works.

It had Office 2000 and at the time, just Accesss was updated to XP. I have
since upgraded everything to XP and went to microsoft.com\office to install
any updates in hopes it would fix the problem. But alas, I still get
errors.

Any suggestions???

Michael S. Montoya
 
Hi Michael, I'm no Access expert but I did come across that as well. What I
have found out was that there was a mention to "Open dbs as Database and rst
as Recordset" in the code behind the form and the problem was gone when I
included DAO in the References.

Hope this could be of any help to you.

Alp
 
No, I made sure to check that one as well. Actually, using the Switchboard
wizard, the code it creates sets db and rs as a control. That's when it
errors.

So I manually change it to set rs as dao.recordset (and include the
reference) and it works. However, I don't want to do this all the time and I
want to be able to run switchboards built on other computers.

Michael
 
Back
Top