Unable to print form access, just a hint of other config issues pe

Discussion in 'Access Configuration' started by Thane Campbell, May 25, 2007.

  1. OK, so this has been very frustrating, spent many hours so far and no
    conclusive findings...
    This a corporate environment with multiple Office2003 Pro installed with
    default installs from a network install point. ( they all should be
    similar). Both XP OS and the office installs up to date with patches.
    Typcially we run access databases over Citrix not locally so we havent had to
    deal with the problem, although we have been aware and looking at it for
    almost a year.

    Problem: Showed it self when one of the managers made a simple access
    database and called me when he was unable to print from it. examining it
    beyond prininting we saw he was unable to access the page setup menu. Further
    investigation revealed that when creating a database from any of the Access
    templates an error message is produced "Database Wizard - There was a problem
    building a form or report" Seaches for any information on this message reveal
    nothing.
    *Naturally we may think perhaps a permission problem, not the case the user
    is administrator to the local machine.
    *Running both regmon and filemon do not reveal any failures
    *Problem is repeatable on some machines and not others
    *Problem is repeatable amongst some users and not others
    *Anwhere the print problem exists on the test database, the user will also
    get errors if they try and create a database from template. So i think there
    are dependecies there, yet I might be able to come behind and use the "run
    as" command and start the application and it will create the database without
    error. (again both would be administrator so rights should be no issue)
    *it appears a crap shoot as to whether it works or not, mostly not
    *uninstall and reinstall does not fix it
    *have replaced the Access registry key from a working machine to a test with
    no result.
    This is taking way too much time to resolve does anyone have ideas please?
    Thanks in advance.
     
    Thane Campbell, May 25, 2007
    #1
    1. Advertisements

  2. Thane Campbell

    Rick Brandt Guest

    Do they have at least one printer driver installed and set as the default
    printer?
     
    Rick Brandt, May 26, 2007
    #2
    1. Advertisements

  3. Yes, on that point I overlooked an obvious information note . these
    workstations are fully functioning and a user might have several printer
    destinations to choose from
     
    Thane Campbell, May 28, 2007
    #3
  4. Thane Campbell

    Alicia C. Guest

    Our clients with this issue are able to print from any other program even other MS Office programs, but not Access.

    The latest change we made is that we replaced all printers in our environment. After the new printers were put in place they took the names of the old printers. The drivers have been updated on all computers. Also, each client has a default printer selected.

    Does anyone have any suggestions on a solution?

    Any help is greatly appreciated.

    Thank you,
    Alicia C.



    ThaneCampbel wrote:

    Unable to print form access, just a hint of other config issues pe
    25-May-07

    OK, so this has been very frustrating, spent many hours so far and no
    conclusive findings..
    This a corporate environment with multiple Office2003 Pro installed with
    default installs from a network install point. ( they all should be
    similar). Both XP OS and the office installs up to date with patches.
    Typcially we run access databases over Citrix not locally so we havent had to
    deal with the problem, although we have been aware and looking at it for
    almost a year

    Problem: Showed it self when one of the managers made a simple access
    database and called me when he was unable to print from it. examining it
    beyond prininting we saw he was unable to access the page setup menu. Further
    investigation revealed that when creating a database from any of the Access
    templates an error message is produced "Database Wizard - There was a problem
    building a form or report" Seaches for any information on this message reveal
    nothing
    *Naturally we may think perhaps a permission problem, not the case the user
    is administrator to the local machine
    *Running both regmon and filemon do not reveal any failure
    *Problem is repeatable on some machines and not other
    *Problem is repeatable amongst some users and not other
    *Anwhere the print problem exists on the test database, the user will also
    get errors if they try and create a database from template. So i think there
    are dependecies there, yet I might be able to come behind and use the "run
    as" command and start the application and it will create the database without
    error. (again both would be administrator so rights should be no issue
    *it appears a crap shoot as to whether it works or not, mostly no
    *uninstall and reinstall does not fix i
    *have replaced the Access registry key from a working machine to a test with
    no result
    This is taking way too much time to resolve does anyone have ideas please?
    Thanks in advance.

    Previous Posts In This Thread:

    Unable to print form access, just a hint of other config issues pe
    OK, so this has been very frustrating, spent many hours so far and no
    conclusive findings..
    This a corporate environment with multiple Office2003 Pro installed with
    default installs from a network install point. ( they all should be
    similar). Both XP OS and the office installs up to date with patches.
    Typcially we run access databases over Citrix not locally so we havent had to
    deal with the problem, although we have been aware and looking at it for
    almost a year

    Problem: Showed it self when one of the managers made a simple access
    database and called me when he was unable to print from it. examining it
    beyond prininting we saw he was unable to access the page setup menu. Further
    investigation revealed that when creating a database from any of the Access
    templates an error message is produced "Database Wizard - There was a problem
    building a form or report" Seaches for any information on this message reveal
    nothing
    *Naturally we may think perhaps a permission problem, not the case the user
    is administrator to the local machine
    *Running both regmon and filemon do not reveal any failure
    *Problem is repeatable on some machines and not other
    *Problem is repeatable amongst some users and not other
    *Anwhere the print problem exists on the test database, the user will also
    get errors if they try and create a database from template. So i think there
    are dependecies there, yet I might be able to come behind and use the "run
    as" command and start the application and it will create the database without
    error. (again both would be administrator so rights should be no issue)
    *it appears a crap shoot as to whether it works or not, mostly not
    *uninstall and reinstall does not fix it
    *have replaced the Access registry key from a working machine to a test with
    no result.
    This is taking way too much time to resolve does anyone have ideas please?
    Thanks in advance.

    Re: Unable to print form access, just a hint of other config issues pe
    Thane Campbell wrote:

    Do they have at least one printer driver installed and set as the default
    printer?

    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com

    Yes, on that point I overlooked an obvious information note .
    Yes, on that point I overlooked an obvious information note . these
    workstations are fully functioning and a user might have several printer
    destinations to choose from

    :


    Submitted via EggHeadCafe - Software Developer Portal of Choice
    Producer/Consumer Queue and BlockingCollection in C# 4.0
    http://www.eggheadcafe.com/tutorial...6d-b81ee8d9b314/producerconsumer-queue-a.aspx
     
    Alicia C., Jun 2, 2010
    #4
  5. Thane Campbell

    Alicia C. Guest

    If you go into the "Printers and Faxes" do shift/right click on your default printer go to "Run as" click "Properties" log on as an administrator. Click "OK" and go to the "Advanced" tab. Under driver, select a different driver than the one the printer is currently using, click "Apply" and then change the driver back to the correct one. Click "OK" Now try printing and or loading a report. This worked for me! I hope it helps someone else.
    -Alicia C.



    Alicia C. wrote:

    Having the exact same issue.
    02-Jun-10

    Our clients with this issue are able to print from any other program even other MS Office programs, but not Access.

    The latest change we made is that we replaced all printers in our environment. After the new printers were put in place they took the names of the old printers. The drivers have been updated on all computers. Also, each client has a default printer selected.

    Does anyone have any suggestions on a solution?

    Any help is greatly appreciated.

    Thank you,
    Alicia C.

    Previous Posts In This Thread:


    Submitted via EggHeadCafe - Software Developer Portal of Choice
    MSChart For VB.Net
    http://www.eggheadcafe.com/tutorial...4dc6-9aa7-4f6246763650/mschart-for-vbnet.aspx
     
    Alicia C., Jun 2, 2010
    #5
  6. Thane Campbell

    Alicia C. Guest

    Go into the "Printers and Faxes"
    Do shift/right click on your default printer
    go to "Run as" click "Properties"
    log on as an administrator
    Click "OK" and go to the "Advanced" tab.
    Under driver, select a different driver than the one the printer is currently using, click "Apply"
    Now change the driver back to the correct one.
    Click "Apply", click "OK"
    Now try printing and or loading a report.
    This worked for me! I hope it helps someone else.
    -Alicia C.



    Alicia C. wrote:

    Having the exact same issue.
    02-Jun-10

    Our clients with this issue are able to print from any other program even other MS Office programs, but not Access.

    The latest change we made is that we replaced all printers in our environment. After the new printers were put in place they took the names of the old printers. The drivers have been updated on all computers. Also, each client has a default printer selected.

    Does anyone have any suggestions on a solution?

    Any help is greatly appreciated.

    Thank you,
    Alicia C.

    Previous Posts In This Thread:


    Submitted via EggHeadCafe - Software Developer Portal of Choice
    XAML Organizer
    http://www.eggheadcafe.com/tutorials/aspnet/ac373a5d-e497-4e07-9186-12166e83a024/xaml-organizer.aspx
     
    Alicia C., Jun 2, 2010
    #6
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.