Multi-users write the same table

M

Minnow

I have one Access database on server. I want more than one users input data
to the same table in the same database at same time. Is this possible? How?
Thanks a lot.
 
V

Van T. Dinh

Yes.

Out of the box, Access will allow that.

For a multi-user system, it is recommended that you should split the
application to Front-End (GUI) and Back-End (Data only).
 
M

Minnow

Thank you guys for reply.

For now, I have only 2 users and security is not an issue. And I don't have
GUI. Users open the database in MS Access application.

Please give me the detail to split the database.
 
T

Tony Toews

Minnow said:
Please give me the detail to split the database.
Click to expand...

You want to split the MDB into a front end containing the queries,
forms, reports, macros and modules with just the tables and
relationships. The FE is copied to each network users computer. The
FE MDB is linked to the tables in the back end MDB which resides on a
server. You make updates to the FE MDB and distribute them to the
users, likely as an MDE.

See the "Splitting your app into a front end and back end Tips" page
at http://www.granite.ab.ca/access/splitapp/ for more info. See the
Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. The utility also supports Terminal Server/Citrix quite
nicely.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Top