Switchboard Wizard Problem

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!!!

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=kb
http://www.microsoft.com/downloads/d...DisplayLang=en

Hope this helps or sends you in the right direction.

"Andy" wrote:

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!!!