sharing a file

[jeb]

I am having a problem with multi-users editing an Access
file at the same time on a network. The file is on one pc
and is shared but mutil-users can not be using the file at
the same time.

 

[Guest]

As i understand, only one user can edit and be making
changes to a database at one time. Other users may have
it open and make changes to a different table, but not
the same one the other user is editing.

 

[Tony Toews]

I am having a problem with multi-users editing an Access
file at the same time on a network. The file is on one pc
and is shared but mutil-users can not be using the file at
the same time.

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 my website for more info. See the Auto FE Updater downloads page
at my website to make this relatively painless.. It 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

 

[Tony Toews]

As i understand, only one user can edit and be making
changes to a database at one time.

For obects this is correct.

Other users may have
it open and make changes to a different table, but not
the same one the other user is editing.

Not quite. Only one user at a time can make design changes to a table
and all other users must not be in that table. However multiple users
can add/update/delete records in the same table at the same time.

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