Access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a mdb file that was working perfectly until yesterday.

Series of events.

11/05/2004 Windows NT 4.0 server w/ Win 98 clients.
11/10/2004 Replaced Win 98 clients w/ Win XP Pro clients. Reports were able
to be printed.
11/20/2004 Replace Win NT 4.0 server w/ Win 2003 Server. Everything works
except none of the reports can be opened, designed or previewed now in
database. Obviously it was something to do with the rights but the users
have full rights on the folder.

Thanks
Tom
 
Tom,

Printers ...... ? Were they all on served from the NT
server? Check for default printers and then check the
report page setup for specific printers.

HTH,

Terry
 
Tom:

Terry's comment is spot on, however, you may find that in certain
situations, you can't open your reports in design mode to change the
printers if the original network printer that a report was set to use no
longer exists on the network. If you can open it in design mode and then
from File - Page Set Up, reset the report to use either the default printer
or a new specific printer on the network. If you can't get the report to
open in design mode, then if the NT box is still around, re-add it to the
network as a BDC or member server (assuming that the printer targets are
still set up properly on that box and you don't change its computer name)
and then you should be able open the reports and then set them, as noted
above, to either user the default printer (recommended) or a new specific
printer based on the convention used by the 2003 server.
 
I did move the database file and workgroup administrator file to another
workstation that is not on the same domain (a NT 4.0 domain) and it works
fine.
I then moved the database file that I could open up on the other domain to
the local workstation on the W2K3 domain and it shows the same condition. I
cannot open the reports, go into design view, etc.
 
Back
Top