473,246 Members | 1,441 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,246 software developers and data experts.

strange error messages when trying to create reports in Access

I am getting strange print-related error messages when trying to
create (not print!) reports. For example, when I click 'new' to create
a report then choose 'design view', I get an error message that says:

'There was a problem retrieving printer information for this object.
The object may have been sent to a printer that was unavailable.'

When I choose 'report wizard', I can go through all of the steps but
then I get an error message at the end that says:

'The wizard is unable to create your report.'

Up to this point, I have been able to create (and print) numerous
reports in this database (around 20) with no problems at all. These
error messages just started occurring since our office move a few days
ago.

At first, there were also printing problems: I would try to print a
report, didn't get an error message, but nothing happened at the
printer. I was told by Help Desk reps that was just a printer memory
issue (even though these are very short reports, usually just one page
long), and that I would need to switch the printer offline then online
again. That seemed to work, but now that printer is defunct (and so
I'm printing to other printers now). Anyway, could those printer
problems somehow have corrupted the database? Is it possible to fix
this somehow? (I was told that I shouldn't do a 'database repair'
procedure using the 'tools' option because it would damage the
database - I'd lose my ID, or something like that.)

The Help Desk people re-imaged my PC and installed all new office
software (while saving all my office files, such as the database with
the glitches I just described), but the error messages are still
occurring.

So far, the only way I have been able to create a new report is by
going back to an old one and modifying it. But, so far as I know, that
won't work when I need to create reports with various grouping levels
(grouping data by status category, for example).

Can the database still store data effectively if it has some
(hopefully minor) corruptions like the ones mentioned above?

Part of the problem is that the database is being shared on a network
drive; both the database designer (me) and the end users have access
to it. Anyway, I try to make new queries and reports in previous
versions copied to the C drive, and then import these features into
the version on the S drive (to minimize the time I'm spending doing
any database modifications while end users might be inputting data
into the database).

Also, I have been backing up the network drive version onto my hard
drive - but as it turns out, the network drive and the local drive
have been trying all along to 'synchronize' with each other and there
have been various synchronization issues because of this. After the
re-imaging, the database was put on a directory on the hard drive that
synchronizes with the network drive. I didn't know that this
synchronization process was occurring, but anyway, that is one
possible reason for the apparent database corruption.

There are "clean copies" stored on disk for this database, but if use
those, the end users (or I) would have to input their project status
data all over again.

By the way, I was told a while back in this usergroup that the best
approach would be to have a split database, with the front end
installed on each user's local drive and the back end installed on the
server. But the response I got from the Help Desk people here was that
since we don't have a database administrator on staff, they could not
support this function (of installing the back end of a split database
on the server). So, we had to stick with just sharing the database on
a network drive - even though someone already mentioned in this
newsgroup that this approach coud lead to eventual database
corruption.

The Help Desk people don't know what can be done about these error
messages, so I thought I would post to this group. Hope to hear from
someone soon about this. Thanks in advance for any help that you can
provide!
Nov 12 '05 #1
1 2619
It sounds like your default printer in Windows is set to a printer that's
off-line. Try chaning it to one of the printers that's on-line. If the
printer juggling is really bad, you can create a local "printer" that outputs
to FILE:, and select that as your default.

On 23 Jan 2004 08:10:36 -0800, kr***@hotmail.com (intl04) wrote:
I am getting strange print-related error messages when trying to
create (not print!) reports. For example, when I click 'new' to create
a report then choose 'design view', I get an error message that says:

'There was a problem retrieving printer information for this object.
The object may have been sent to a printer that was unavailable.'

When I choose 'report wizard', I can go through all of the steps but
then I get an error message at the end that says:

'The wizard is unable to create your report.'

Up to this point, I have been able to create (and print) numerous
reports in this database (around 20) with no problems at all. These
error messages just started occurring since our office move a few days
ago.

At first, there were also printing problems: I would try to print a
report, didn't get an error message, but nothing happened at the
printer. I was told by Help Desk reps that was just a printer memory
issue (even though these are very short reports, usually just one page
long), and that I would need to switch the printer offline then online
again. That seemed to work, but now that printer is defunct (and so
I'm printing to other printers now). Anyway, could those printer
problems somehow have corrupted the database? Is it possible to fix
this somehow? (I was told that I shouldn't do a 'database repair'
procedure using the 'tools' option because it would damage the
database - I'd lose my ID, or something like that.)

The Help Desk people re-imaged my PC and installed all new office
software (while saving all my office files, such as the database with
the glitches I just described), but the error messages are still
occurring.

So far, the only way I have been able to create a new report is by
going back to an old one and modifying it. But, so far as I know, that
won't work when I need to create reports with various grouping levels
(grouping data by status category, for example).

Can the database still store data effectively if it has some
(hopefully minor) corruptions like the ones mentioned above?

Part of the problem is that the database is being shared on a network
drive; both the database designer (me) and the end users have access
to it. Anyway, I try to make new queries and reports in previous
versions copied to the C drive, and then import these features into
the version on the S drive (to minimize the time I'm spending doing
any database modifications while end users might be inputting data
into the database).

Also, I have been backing up the network drive version onto my hard
drive - but as it turns out, the network drive and the local drive
have been trying all along to 'synchronize' with each other and there
have been various synchronization issues because of this. After the
re-imaging, the database was put on a directory on the hard drive that
synchronizes with the network drive. I didn't know that this
synchronization process was occurring, but anyway, that is one
possible reason for the apparent database corruption.

There are "clean copies" stored on disk for this database, but if use
those, the end users (or I) would have to input their project status
data all over again.

By the way, I was told a while back in this usergroup that the best
approach would be to have a split database, with the front end
installed on each user's local drive and the back end installed on the
server. But the response I got from the Help Desk people here was that
since we don't have a database administrator on staff, they could not
support this function (of installing the back end of a split database
on the server). So, we had to stick with just sharing the database on
a network drive - even though someone already mentioned in this
newsgroup that this approach coud lead to eventual database
corruption.

The Help Desk people don't know what can be done about these error
messages, so I thought I would post to this group. Hope to hear from
someone soon about this. Thanks in advance for any help that you can
provide!


Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Serious_Practitioner | last post by:
Hello, all - A few days ago, I posted the following message - Hello all, and thank you for your help in the recent past. Got a new error message in the last few days. While working with...
3
by: Niranjan Roy | last post by:
When trying to create Web application project from inside my Visual Studio.Net, I am getting the following error: --------------------------- Microsoft Development Environment ...
3
by: Jim in Arizona | last post by:
I'm going insane! I don't know if it's just that the .net 2.0 framework is buggy or if it really is my code. This is pretty hard to explain since I can't even begin to nail down why this is...
16
by: lawrence k | last post by:
I've made it habit to check all returns in my code, and usually, on most projects, I'll have an error function that reports error messages to some central location. I recently worked on a project...
3
by: sara | last post by:
Very strange behavior, but I suspect some is A2K and some might be for me to correct. Just trying to see if anyone can help and advise. We have a database that's been running for a few years...
3
by: Santosh | last post by:
Hii , i am developing an web application using asp.net with in it reporting purpose i am using crystal reports. it is working on fine on local server. but when i deploy it on web server it gives...
5
by: Jeff | last post by:
Okay, I'm still new to vb.net 2005 - throught this was a hardware problem, but now I don't know. (I'm having some problem with my newgroup provider, so hopefully this will go through) This...
2
hyperpau
by: hyperpau | last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding. I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com). Ergo, I...
0
hyperpau
by: hyperpau | last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding. I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com). Ergo, I...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.