Switchboard Wizard Problem

[Guest]

Beginning to try and get to grips with a switchboard. Database with one
table, one query (make table), and one macro (runs query).

On running the 'Swtichboard Wizard', everything seems fine until I go into
the form and get a VBA error.

Run-time error '-2147220999 (800401f9)':

Method 'Connection' of object '_CurrentProject' failed

Clueless with VBA. As it's just a 'wizard', why won't it work!!!

 

[Guest]

Andy,

Check out www.prtracker.com/support/pr948.html

it states that it is a currupt MDAC. (Microsoft Data Access Compnents) For
some reason I found this very hard to find here on the various Microsoft
sites and on the Web. This page refers you to 2 Microsoft sites for a
possible way of fixing it.

http://support.microsoft.com/default.aspx?scid=k
http://www.microsoft.com/downloads/...df6-4a21-4b43-f53-14332ef092c9&DisplayLang=en

Hope this helps or sends you in the right direction.