Multi User database

  • Thread starter Thread starter Vina
  • Start date Start date
V

Vina

Can someone help me on how I can make a database
multiuser.
I need to allow users to access and run queries and
modify tables at the same time.

is this possible.
Thanks
Vina
 
Can someone help me on how I can make a database
multiuser.
I need to allow users to access and run queries and
modify tables at the same time.
Click to expand...

Access is multiuser by default, out of the box. You must go to some
extra effort to open it exclusively!

On the other hand, if you're talking about modifying the STRUCTURE of
tables while someone else is querying the same table, you won't be
able to do so. You can modify the *data* in a table (using a form or a
datasheet) while someone else is viewing the data; you won't be able
to have the same record open for both users but other records should
be ok.
 
"Vina" wrote
Can someone help me on how I
can make a database multiuser.
I need to allow users to access
and run queries and modify tables
at the same time.
Click to expand...

There's an introductory presentation on Access in a Multiuser Environment
that I did for my user group that you can download from
http://appdevissues.tripod.com. It will identify topics that I thought
worthwhile to discuss, and a bit more. The best collection of detailed
information and links on the subject of Access in the multiuser environment
is at MVP Tony Toews' site, http://www.granite.ab.ca/accsmstr.htm.

Larry Linson
Microsoft Access MVP
 
Back
Top