Getting Microsoft Access error "The open report action was cancelled".

I am using a standard Microsoft Access database. I have 2 machines one with the smart label printer connected via USB. This printer is shared (i.e \\user\printer) to the second PC.
My problem is i can't print a label address from the database onto the smart label printer using the second PC. when i attempt to preview the label i get the following error "This document was previously formatted for the printer smart label printer 450 on USB002, but the printer isn't available.
It gives me 2 options first is to "preview" and second to select "setup"
If i select preview i get the following error; "The OpenReport action was canceled".
If i select "setup" i have the options for margins, page columns and the option to chosse either the default printer or select one from the list. My smart label printer isn't the default so i choose it from the drop down.
I have set the margins to the correct size and all other settings. There is only one option that is grayed out. This is for the paper size. The other machine has this set to 54mm x 101mm. For some reason i can't choose this option. The drop down just shows a blank list.
I have installed the smart label printer from the CD and drivers from the website. I though this may provide me with the settings for that drop down box. Unfortunately the list remains empty.

Any ideas?

Thanks in advance.
rutlandictAsked:
Who is Participating?
 
rutlandictAuthor Commented:
I'm afraid our client has now purchased a new smart label printer for the second PC. Sorry for waisting your time.
0
 
peter57rCommented:
Are the two pcs identical?
0
 
rutlandictAuthor Commented:
To peter57r:

They are identical. The only difference is the first PC has Access 2003 rather than 2002. But apart from this they are the same OS, files etc.

Thanks.  
0
 
Jeffrey CoachmanMIS LiasonCommented:
Under what scenario does this function normally...?
0
 
rutlandictAuthor Commented:
I'm afraid our client has now purchased a new smart label printer for the second PC. Sorry for waisting your time.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.