Report problem

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

Guest

Hello,

I have a user who has a funky issue. There's a data base on a shared drive
that he uses for some simple reports. He can't open any reports in design
mode or preview mode and with in VBA, DoCmd.OutputTo yada yada it returns
error 2501 which is the user cancled. I don't know why these reports can't be
opened on HIS machine but I can open them on any other machine with no
problem. Any clues ? Is it a security issue ? I even tried importing the
objects in to another database - no luck.

Thanks in advance.

G-Man
 
Firstly, check that he has some kind of printer installed on his computer.
Access uses the printer metrics to calculate the layout of the reports, so
it may not work if no printer is installed, or the printer is not correctly
installed.

There have been reported issues with Access 2003 and a network printer. If
this is the setup, open the Immediate Window (Ctrl+G) and enter these lines:
? Printers.Count
and then:
? Printer.DeviceName
If Access is unable to find the printers, even though they are installed,
the printer installation is still the problem.

If that is not the case, open a code window and choose References on the
Tools menu. Look for any library that is checked, but marked "MISSING". More
on references at:
http://allenbrowne.com/ser-38.html

If none of that applies, how is this user logged into Windows? Try logging
in as an administrator on that machine (not just a regular user) to see if
Windows permissions are an issue.

It is also possible that the database is partially corrupt, but you say that
the file works if copied to another machine, so that sounds unlikely.

HTH
 
Back
Top