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?

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.

Show quoteHide quote

minnesotagirl <minnesotag***@discussions.microsoft.com> wrote:

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

Re: Access to DB lost
Workgroup file connection problem!!!
secured database doesn't open on new server
User Permissions
Set password for groups
Securing Form Entries
How do I change the user logged into MS Access?
Access 2007 security and the Access 2003 system.mdw file
Access 2007 System.mdw Default Location
VBA Security warning