Multi user vs single user

[teqtaq]

Hi!
I had placed Access2003.mdb with linked Oracle tables on share drive and all the users were given permissions to run reports.
However only 1 user can run 1 report.
After the first run error message pops up that table *** is used by another user. So 1 user can not run 2 reports on a row.
So do I ned to write some code to release the table after first run?
Also whom am I suppose to ask for multi environment set up?
Thanks

 

[JoeAtWork]

The best practice is usually to give each user their own copy of the front-end MDB file.