Access 2002 shuts down

  • Thread starter Thread starter Max
  • Start date Start date
M

Max

Windows XP
Access 2002

I have a report that prints out the same address in an unbound text box to a
C5 envelope.

If I select the report in the Reports window and then Print, it works fine.
If I use code to do the same thing Access exits without a prompt. The same
thing happens if I try to open the form in design view.
I have full permissions on this database, and I have already tried
recreating the database from new and importing all the elements but still
the problem persists. None of the references are missing.

Any suggestions?

Thanks in advance,

Max


Code:
Dim DocName As String

DocName = "C5WerndaleNat"
DoCmd.OpenReport DocName, acNormal
 
Hi Max.

Ken is probably right about the cause of the problem. Perhaps your database
is damaged to the point where it needs to be rebuilt.

1. Create a new database:
File | New.

2. Immediately uncheck the Name AutoCorrect boxes under:
Tools | Options | General

3. Import everything from the old database:
File | Get External | Import
 
Oops.
Just when I thought things were fine.
After a re-boot of the computer the problem has returned.

Any more suggestions?

I do not know if it is relevant but I had upgraded to SP3 and then the
problem seemed to arise.

Max
 
If this happens with only one report, create a new database, turn off Name
AutoCorrect, and import all the *other* objects. Then recreate that one
report.

If it happens more broadly or intermittently, it is possibly an interaction
between Access and another piece of software that you have running, such as
an anti-virus program, email client, screen changer or screen saver,
spyware, or even a bad printer driver (since reports use that also.)
 
None of these suggestions worked.

I finally sorted this one out.
I renamed the printer driver, formated the form to print to this, and all
worked fine.

Why?
Anybodies guess.

Max
 
Back
Top