[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Access report

Posted on 2012-04-03
7
Medium Priority
?
236 Views
Last Modified: 2012-04-04
I've a local access database, in 2000 format, and all reports doesn't open in preview. If I copy the same db in another pc all works well.
No one error is displayed.
What can I do?



Thank you
0
Comment
Question by:fantamen
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 1500 total points
ID: 37801024
I'd suggest checking that you do have an default printer associated with this computer.

Even if you are only opening an Access report in print preview, I believe it does look for a printer.

Also, open a code module, and from the VBA Editor:

Tools --> Options -->  Under the General tab, select "break on all errors" (temporariliy!)

Try running your report(s) again with this setting and see if you get an error.

Revert that setting to "break on unhandled errors" when you are done testing this.
0
 
LVL 48

Expert Comment

by:Dale Fye
ID: 37801032
I know you said the database is "in 2000 format", but you didn't indicate which version of Access are you running on each of the PCs?

How are you attempting to open the reports?

If you are running Access 2007 on the PC which is encountering the problem, this could be a trusted macros issue.
0
 

Author Comment

by:fantamen
ID: 37801175
Changing default printer appear this error: communication ole db error or aCtiveX control. Access il 2003 version.
There are no macro executed on startup.
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

Author Comment

by:fantamen
ID: 37801203
Pc is not mine, I think this happen after a program installation.... that probably change something....
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37801255
Is this an issue/problem on only one isolated PC?
What is the OS?, what version of Access?, ...etc?

Make sure that PC has all of it's updates installed for Windows and Office.

In other words, compare the specs of the machines that this works fine on, with the specs of the PC that has this issue.
As close as possible, try to make the configuration (Software and updates, but to a lesser extent, hardware) of the bad PC the same as the PCs that work fine (if possible)

Note that Access 2000 is 12 year old technology
Since a great many files are shared with the OS and Office, there is no way to be certain that an Access 2000 format DB will run flawlessly on a newer configuration.

JeffCoachman
0
 

Author Comment

by:fantamen
ID: 37801304
It happen only in one pc with Windows XP service pack 3.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37801839
Obviously there is a difference...

Again, what is the configuration of the machines that this works fine on?

Is it an option to simply reload the machine (if loaded from an image), or just use a machine that it does work on?

Perhaps there is a simple solution here, perhaps we could guess at this for days...

Let's see what the other experts post...

JeffCoachman
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question