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

T

Thane Campbell

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.
 
R

Rick Brandt

Thane said:
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.

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

Thane Campbell

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
 
A

Alicia C.

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
 
A

Alicia C.

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
 
A

Alicia C.

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
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Top