multiple users problem

[Will]

I have created a database that stores information and then on a click of a
button, based on the users selections from a main page (form) queries the
data returning the results on a new form. I have also created a button to
open a report that show the same data. As part of the report button click
event I create a copy of the report and change the record source to match
their selections. Everything works fine for one user but when multiple users
are in the tool at the same time no one can open the report. If someone has
the report open no one else can get into the tool. Any suggestions?
Thanks.

 

[Jeff Boyce]

Will

Any chance all of the users are pointed at a single database file? That
might cause the kind of contention you seem to describe.

The solution (and a less-brittle design) would be to have each user have
his/her own copy of the "front-end" on his/her PC, all connected to (linked
table) a "back-end" on a shared network that holds only tables.

Regards

Jeff Boyce
Microsoft Office/Access MVP