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?

printers installed?

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


"Erik the bikeman" wrote:

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

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/
__________________________________________

"Erik the bikeman" wrote:

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

"Tom Wickerath" <AOS168b AT comcast DOT net> wrote in message 
news:2F978341-41EE-4ECE-B396-A5FBFABA5BFD@microsoft.com...
> 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/
> __________________________________________
>
> "Erik the bikeman" wrote:
>
>> 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?