Multiple Users instantaneously

[Guest]

Access 2003,

I have a database on a network and i need multiple users to use it at the
same time. However, they all have access to similar data.
How can i let them use this data at the same time. It gives me the error
message "currently being used by (user)"
Matt

 

[David F Cox]

Obviously only one user can be updating one thing at one time. Are you
perhaps using updateable queries where you do not need to?

If the query display in datasheet mode has a blank line with an * at the
bottom, it is updateable. One quick fix to make a query not updateable is to
make a field calculated e.g. Quantity: [qty] + 0

 

[Van T. Dinh]

Generally, for a multi-user Access database application, you should split
the database to Front-End and Back-End MDB file. The Back-End contains only
Tables and reside on a (file) server shared directory. The Front-End
contain other Access objects and each user should have his own copy of the
Front-End on his work-station.

See tony Toews' Web site for more info.:

http://www.granite.ab.ca/access/splitapp/index.htm