Jim Lawrence
accessd at shaw.ca
Mon Aug 21 11:18:19 CDT 2006
Thanks for the FYI blurb... Have been there, done it and in my case, took about a week to discover the reason. This will definitely help someone in the future. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tesiny, Ed Sent: Monday, August 21, 2006 8:02 AM To: Access Developers discussion and problem solving Subject: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com