Results 1 to 11 of 11
  1. #1
    Star Lounger
    Join Date
    May 2002
    Location
    Auckland, North Island, New Zealand
    Posts
    74
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Printer (Access2002)

    <img src=/S/boxedin.gif border=0 alt=boxedin width=25 height=20> The techo's over the weekend have installed a new Network server with a Samba Print Server??
    When I print anything (table, query, report) from my data.mdb, it all prints fine. So do files in Word and Excell.
    However, when I try to print anything from program.mdb, an error message appears (and I cant find the paper with the exact words, darn it, to the effect that ) you don't have access to the printer. When the techo's give me direct access to the printer, I can print. So it is something within my Access Program which causes the problem. We have searched high and low for a specific printer/default printer setting but cannot find such a control.
    (Must say that Access 2002 is very annoying in that you cannot even open a report in Design mode without having a printer attached. Or is that part of my problem as well??)

    John

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Default Printer (Access2002)

    In 2002, you can design and even preview a report without a printer installed. That's one of the small differences between 2000 and 2002.
    Charlotte

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Default Printer (Access2002)

    Is Program.mdb a runtime application? Is it opened from a shortcut? What exactly are you trying to print from Program.mdb?
    Charlotte

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Default Printer (Access2002)

    Oops, you're right. Thanks for catching this. I'll edit my reply.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Default Printer (Access2002)

    <P ID="edit" class=small>(Edited by HansV on 19-May-03 14:36. Added remark about reports in Access 2002.)</P>1. The problem seems to be specific to one database, since you *can* print from Data.mdb. What happens if you create a new database and use File | Get External Data | Import... to import all database objects from Program.mdb? Can you print from your new database?

    2. In Access 2.0, you could design a report without having a printer installed, but not in Access 95 and later versions. See <!mskb=145576>Microsoft Knowledge Base Article 145576<!/mskb>.
    Added: In Access 2002, it is possible again to design a report without having a printer installed. Thanks to Charlotte for pointing this out.

  6. #6
    Star Lounger
    Join Date
    May 2002
    Location
    Auckland, North Island, New Zealand
    Posts
    74
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Default Printer (Access2002)

    Thank you Hans and Charlotte for your responses. Sorry for the delay in responding but the techno's have been sorting out the new network some more, and we have come up with some more specifics to the problem.
    Just confirming I am using Access 2002 and the database is created in that mode as well. OS is Win2K and Win XP.
    If we print to a local printer, or to the old Windows print server, everything works fine. As soon as we switch to the Linux server with a Samba print Server, the problems start.
    When the default printer is connected to the Samba server, the printer icon shows "No Printer" instead of the usual printer name. Accessing the default samba printer thru the usual keystrokes or menu commands or the printer icon brings up a message (I don't have the exact words with me as I type this) to the effect that we do not have access to an installed printer.
    When the default printer is a local printer, we can get the report on the screen as a print preview, then Ctrl-P and change the printer to the Samba Printer, and everything works fine.
    This problem is only happening with Access. All other programs (Word, etc and other non MS programs) are printing fine to the samba printers.

    Any more ideas??
    John

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Default Printer (Access2002)

    In your first post in this thread, you stated that you could print from Data.mdb without problems. Does that include printing from Data.mdb to a Samba printer, or only to a local printer or one on the old Windows server?

  8. #8
    Star Lounger
    Join Date
    May 2002
    Location
    Auckland, North Island, New Zealand
    Posts
    74
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Default Printer (Access2002)

    I have to say that in retrospect, I can't be sure. Several people were doing several things and it may be that the direct ip printer had been established at that time. Definitely now, can't print from any Access file to the samba printer. A direct ip accessed printer is in effect a local printer.
    Sorry I forgot to correct that earlier misinformation.

    John

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Default Printer (Access2002)

    Access is more highly Windows-centric than the other programs, which also have Mac versions, and 2002 is the most Windows-specific version yet. The Samba server would be in another network domain, so it may be necessary to map it as a node to your Windows network before Access will recognize it. This isn't exactly an Access problem, I think. That is, it manifests in Access, but it isn't anything you can cure from Access.
    Charlotte

  10. #10
    Star Lounger
    Join Date
    May 2002
    Location
    Auckland, North Island, New Zealand
    Posts
    74
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Default Printer (Access2002)

    Thanks Charlotte.
    Advice from the Techno concerned states "The samba server is in the SAME domain. In fact it is the DOMAIN
    controller for the PCs at this site".

    I am about to search the MS Knowledge base, I must confess without much hope considering samba is not an MS product.

    John

  11. #11
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Default Printer (Access2002)

    The problem is that Access doesn't really know anything about printers, it's Windows that knows printers. The only time I've seen Access actually misbehave with printers and fail to recognize them is when using the new Printers collection and the PrtDev and Printer objects in 2002 or when a PDF printer has been installed that is private to an application. Some of those will grab the default and hold on to it, so that when you try to print, Access is attempting to print to something it can't talk to. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •