multi users of 1 report

[Guest]

I have a report button which calls a procedure to run many queries & then
opens a report. In a multi user environment how do I prevent users from
bumping into each other, ie from attempting this button at the same time?
Thanks.

 

[Joseph Meehan]

I have a report button which calls a procedure to run many queries &
then opens a report. In a multi user environment how do I prevent
users from bumping into each other, ie from attempting this button at
the same time? Thanks.

Use a split database system with a back end on the LAN shared by
everyone containing only the dynamic data, no forms queries reports etc.

Each user than has a front end containing static data tables and all the
forms, reports and queries etc that they need.

 

[Larry Daugherty]

Each user should have a copy of the Front End (you have split your
application, haven't you") on their pc.

HTH