Jürgen Welz
jwelz at hotmail.com
Thu Jan 26 11:15:50 CST 2006
Dealing with the nITzis for a couple days now on something that might be of interest. I had a couple users who couldn't open a report and Access throws a '2501 The OpenReport action was canceled.' I have functions that change default sql parameters based on the user and their office and IT sets up rights to folders and I've got my own security running and some data if from various sources that require drivers. It turns out that these users can't even use File - Print Preview on a plain lookup table. Opening any preview from the database window results in a silent failure. Opening any report from the Immediate window with a docmd OpenReport produces the error message. IT tells me it is my problem because Access throws an error on my button click event. The problem is that, apparently unlike other MS Office applications, Access uses some kind of print driver information to generate a print preview. The problem is the same as when no printer is installed. In this case, it is a problem with a Canon printer driver. It took me nearly two hours to track down this problem a year ago when IT added a paper tray to one of the other office printers. It was a particularly complex and convoluted report that a user was trying to open so there were dozens of things to check and I finally got permission to log in the user to track down the problem. Lacking the basic ability to create a table with two entries and to select Print Preview from the file menu, IT asked me to send them a new MDB that demonstrated this problem outside of my application. Of course Outlook blocked the attachment so I was asked to rename the file extension. Their security prevents rename of file extension from Explorer (though it's easy enough in VBA and though I can no longer get a DOS window, I can shell a 'ren' command). We finally have zip capability and I think these email OK. Being bloody minded, I ask them how to rename the file extension and send an html link to the file instead. This is ongoing. In the mean time, I tell the users to select any other printer in the office as their default printer. Ciao Jürgen Welz Edmonton Alberta jwelz at hotmail.com _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/