does access drive you crazy?

[binghamw]

Hi,
I have a few forms that contain a command print button.
It works fine except for one thing. It seems that when it prints a report, the whole database seems to shut down.

This is the code I have in my on_click command print button:

DoCmd.OpenReport "rpt_frmDept", acViewNormal, , "[File]=Forms!frmDept!File"

I can not figure out why it is doing this. I have just recently switched to a frontend/backend database whereas before it was all together. I didn't have these problems until I converted it.

any ideas?

 

[The_Doc_Man]

Do you mean that other users in the same database at the same time on other workstations seem to shut down?

Might be a locks issue if so. If the report is big enough that it potentially involves the entire database (or at least all of the significant tables therein), you could very well see this phenomenon.

See what your default locking behavior is set for. If it is a report, you might want no locks at all.