I'm having trouble running reports on a different computer in the network at my company. Other computers have no problem running my database, except for one--and it is running Access 2002.
I'm running Access 2000, although some of its tables happen to link to an Access 97 database. I've been able to distribute the secure database to other users, except for one who has Access 2002. On his computer, when he logs in, the following message box shows up:
"Could not load an object because it is not on this machine."
Then it continues to load properly, displaying the switchboard. But no reports will run, even though he has permission even to design them. If he clicks on a switchboard button that is set to open a report, the following error occurs, and the report doesn't open:
"There was an error executing the command."
When a button is clicked that runs a report using code, such as:
Sub RunReport()
DoCmd.OpenReport "rptDeals", acPreview
DoCmd.Maximize
End Sub
the following error message is displayed:
"There was a problem retrieving printer information for this object. The object may have been sent to a printer that is unavailable."
after which Access 2002 hangs, and the only way out (short of Ctrl-Alt-Del) is to click the close button (the "X"
on the upper-right hand corner of the window.
Does anyone know what the object might be that is not on his machine, and how to solve that, and whether that will solve the other problems; or otherwise, how to solve those?
Any help is much appreciated.
-Christopher
I'm running Access 2000, although some of its tables happen to link to an Access 97 database. I've been able to distribute the secure database to other users, except for one who has Access 2002. On his computer, when he logs in, the following message box shows up:
"Could not load an object because it is not on this machine."
Then it continues to load properly, displaying the switchboard. But no reports will run, even though he has permission even to design them. If he clicks on a switchboard button that is set to open a report, the following error occurs, and the report doesn't open:
"There was an error executing the command."
When a button is clicked that runs a report using code, such as:
Sub RunReport()
DoCmd.OpenReport "rptDeals", acPreview
DoCmd.Maximize
End Sub
the following error message is displayed:
"There was a problem retrieving printer information for this object. The object may have been sent to a printer that is unavailable."
after which Access 2002 hangs, and the only way out (short of Ctrl-Alt-Del) is to click the close button (the "X"
on the upper-right hand corner of the window.Does anyone know what the object might be that is not on his machine, and how to solve that, and whether that will solve the other problems; or otherwise, how to solve those?
Any help is much appreciated.
-Christopher