"There was an error executing a command" in Switchboard

[Erik the bikeman]

Hi,
I'm seeing the above error when trying to run reports from an Access
Switchboard. The error only happens on certain machines but, even on those
machines, the error doesn't appear when connecting to the db through a Citrix
session.
All the workstations have XP SP3 (Jet engine and Access 2003 fully
patched). The server where the database resides runs Server 2008 RC2 - fully
patched.
Any ideas why this happens only on certain computers?

 

[Maurice]

printers installed?

sometimes a pdf printer can cause issues. set antoher defaultprinter and try
again.

 

[Tom Wickerath]

Hi Eric,

First, verify that there are no references marked as MISSING on the affected
computers. This is fairly easy to do if you are working with .mdb files, but
a bit more involved if you are using the compiled .mde form:

Solving Problems with Library References (Allen Browne)
http://allenbrowne.com/ser-38.html

Access Reference Problems (Doug Steele)
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

If that does not solve the problem, then try re-registering the ADO library
on these PC. Click on Start | Run, and enter the following command:

Regsvr32 "C:\Program Files\Common Files\system\ado\Msado15.dll"

The code used in Switchboard forms, starting with Access 2000, is ADO code.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Fernand Cousineau]

Hi Eric,

First, verify that there are no references marked as MISSING on the
affected
computers. This is fairly easy to do if you are working with .mdb files,
but
a bit more involved if you are using the compiled .mde form:

Solving Problems with Library References (Allen Browne)
http://allenbrowne.com/ser-38.html

Access Reference Problems (Doug Steele)
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

If that does not solve the problem, then try re-registering the ADO
library
on these PC. Click on Start | Run, and enter the following command:

Regsvr32 "C:\Program Files\Common Files\system\ado\Msado15.dll"

The code used in Switchboard forms, starting with Access 2000, is ADO
code.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________