[AccessD] FYI - Access Reports & Printers

Hi All,
I'm posting this as an FYI and hopefully will keep someone else from
having a very bad day.  I have a fairly large Access database that I use
on a regular basis.  On Friday afternoon, doesn't it always happen late
Friday afternoon...I tried to edit a report but I couldn't access the
report, couldn't run it, couldn't view it in design mode, nothing.  All
the tables, queries and forms were accessible, data was there and you
could go into design mode.  Tried all the usual fixes, compact and
repair, reboot, create a new database and import all the objects, etc.,
still nothing, reports were not accessible.  Copied the database to a
shared network drive and two colleagues could run the reports and view
them in design mode.  I sent this info to the OT list and Gary Kjos
kindly responded asking if I had changed my default printer.  Well I
didn't  "change" my default printer BUT MIS replaced my default printer
with a newer model but kept the same network name.  I deleted my default
printer and then added it again, walla all my reports work again.
Hopefully this might save someone a headache in the future.
Regards,
Ed
 
Edward P. Tesiny
Assistant Director for Evaluation
Bureau of Evaluation and Practice Improvement
New York State OASAS
1450 Western Ave.
Albany, New York  12203-3526
Phone:  (518) 485-7189
Fax:  (518) 485-5769
Email: EdTesiny at oasas.state.ny.us