3011 error with no object/file name

[millwheal]

I have a shared Access 2003 database with multiple users all on Windows XP.

One user gets a 3011 error, but the message does not give an object or file name; it simply gives two single quotes at the end of the "cannot find" message.
None of the other users gets this problem when executing the same procedures.

In searching for a possible solution, on this forum and via Google, it seems that this error mainly occurs where there is a split [front-end/back-end] database or a file or object is being imported/exported. Neither of these is true in my example: it is a monolithic database file and the command that causes the error is: DoCmd.OpenReport ... and the Report DOES exist.

Any thoughts on possible causes/solutions would be much appreciated.

 

[boblarson]

Well, for one - if you have multiple users it SHOULD be split and with the Backend (tables only) on the server and a COPY pf the Frontend on EACH USER'S machine. This is really a MUST for multiple users. Otherwise you run very high risks of corruption, as well as things not working for users.

So, my suggestion - split it, give a copy of the FE to each user, and then see if you still have a problem. See here for more about splitting.

 

[The_Doc_Man]

The mode in which you open the report also matters if for some reason you cannot find the default printer and you opened a report in a mode that would print automatically.

 

[millwheal]

Many thanks to Bob Larson and The Doc Man.

Bob: I know about the benefits of splitting and am in the process of trying to persuade people that it is a "must do". The notes you pointed me to will help me win the "argument".

Doc Man: Brilliant! You've hit it on the head; I found out late yesterday that the user did not have a default printer defined. Even then it didn't click in my head that the two things could be connected.