Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 5th, 2005, 03:13 PM
Registered User
 
Join Date: May 2005
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Huge problem with access 2003

Hi,
I'm having a very strange problem creating reports in access 2003. It started on a clean install of office 2003 without any SPs or patches. I'm having this problem on a laptop with WinXP Pro SP2, all other workstations are fine.

The problem is simple but very frustrating. I CAN'T create a new report, modify or execute any report what so ever. When I use the wizard it allows me to select the table or query, the fields ect... and at the end it give me a message that creating the report has been cancelled. It does this on existing DBs, new DBs all DBs.

I've checked the HD for errors, checked for viruses, compacted the DBs, checked the references in access, upgraded to office 2003 sp1, uninstall and reinstall office and I still have the problem.

Any suggestions.

Thank you in advance.

Andy
 
Old May 5th, 2005, 03:18 PM
Registered User
 
Join Date: May 2005
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

By the way, I don't have any problems with the tables, forms, or any thing else.

 
Old May 6th, 2005, 04:22 AM
Friend of Wrox
 
Join Date: Sep 2003
Posts: 155
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to leehambly
Default

What printers have you got installed? If none, then you will need to do something about this... reports use the print preview and without a printer, you cant do this... might be the answer, but might be totally off-track...
 
Old May 6th, 2005, 07:27 AM
Registered User
 
Join Date: May 2005
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

Several printer are installed on the system. One local, HP laserjet 2300 and two network printers as well as the default windows fax. I will check to see which one is the default printer.

Andy

 
Old May 6th, 2005, 08:15 AM
Authorized User
 
Join Date: Jan 2005
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have had exactly the same problem. If you read Knowledge Base article 145576 this gives a hint to the solution. The problem arises when some Network printers are set as the default. There is a conflict between Access reports and the Network printer drivers. The 'techie' solution can probably be found in the black arts of network support, but we found that if you connect a small printer directly to your LPT1 port and set that as your default, everything works fine. You can then even print your reports on the same network printer that gave the original error - weird!



 
Old May 6th, 2005, 08:39 AM
Registered User
 
Join Date: May 2005
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The default printer as present is the local printer. I will change the default printer and see if that works. If it doesn't, I will install a virtual printer and set it as default.

Will post soon with results.

Andy

 
Old May 6th, 2005, 09:06 AM
Registered User
 
Join Date: May 2005
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Well I don't believe it but it's true. I set my default printer to a network printer and (I still can't believe it) it works. My local printer, which was my default printer, is connected to the USB which is the only reasonable explanation. I can now, create, modify and execute a report and print to my local USB printer, which was the cause of my problem.

Thank you so much, I don't believe I would have thought it was the printer without your help.


Andy

 
Old May 6th, 2005, 10:40 AM
Friend of Wrox
 
Join Date: Sep 2003
Posts: 155
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to leehambly
Default

Glad you sorted it... must have been something to do with this, given that it was a laptop and elsewhere all was fine, just very glad I didnt make myself look like a complete plank with a bizarro suggestion ;)
 
Old May 6th, 2005, 10:57 AM
Registered User
 
Join Date: May 2005
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

thank you again.

I'll fire up a nasty little comment to M$ office for not supporting USBs printers.

Andy

 
Old May 20th, 2005, 10:26 AM
Registered User
 
Join Date: May 2005
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have this same problem, i changed the default printer to the document image writer and all works fine, but whats the solution if all the printers are network printers?






Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2003 Problem allenle37 BOOK: Access 2003 VBA Programmer's Reference 2 May 7th, 2007 11:55 PM
Access Problem From Upgrade WinNt -> 2003 BrianWren Internet Information Services 0 March 22nd, 2007 11:39 AM
Date problem in Access 2003 dkyr VB Databases Basics 2 December 28th, 2005 07:38 PM
Windows XP ( +access 2003) problem? belete Access 1 October 11th, 2004 09:19 AM
Access 2003 connection problem umzi ADO.NET 4 July 23rd, 2004 01:04 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.