Multiple Users - Update capacity

[minnesotagirl]

My database is set up as "Shared", but I get an error message when 2 users
are in the database and I am creating a query, data entry etc -- that my
changes won't be saved. What do I have to do to allow for 2 users to save
data at the same time?

 

[Douglas J. Steele]

Having 2 users save data at the same time is no issue. Creating a query
isn't saving data, though, it's making design changes (just like creating a
form or report or adding a module). You must have exclusive access in order
to save design changes.

 

[Tony Toews [MVP]]

My database is set up as "Shared", but I get an error message when 2 users
are in the database and I am creating a query, data entry etc -- that my
changes won't be saved. What do I have to do to allow for 2 users to save
data at the same time?

You want to split the MDB into a Front End MDB containing the queries,
forms, reports, macros and modules with just the tables and
relationships in the Back End MDB. 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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/