Modifying a DB from multiple systems at the same time?

[Apres1]

Hello,
I have been trying to figure this out for a few days now and I am stuck. I
am setting up an Access DB for work purposes. The user will enter data into
multiple forms within the DB, and this will happen in different sections of
the building at the same time. The problem I am having is that once I have
the DB open on one system, all other systems can only open in Read-Only and
cannot enter information unless they save a copy of the DB. I need the DB to
be able to be used dynamically by mulitple systems at the same time, with all
informaiton being stored in the original DB. How do I do this? Is this even
possible?

 

[golfinray]

You need to split your database. That means you have a front end (FE) and
backend (BE). The backend contains all the tables and the FE contains all
your queries, forms, and reports. The BE is loaded on the server that all
users have access to. The FE is loaded on each user's machine. There is a
tool in your ACCESS database that splits it for you. See help for that. One
requirement: You must give read\write\edit\ and delete rights to the BE to
every user AND the same rights to the folder it resides in.

 

[Roger Carlson]

Yes, it is possible.

First of all, you should "split" your application into Front-End and
Back-End. The BE holds only the tables. The FE has everything else with
the tables linked to the BE tables. The BE should be on the server and the
FE should be on everybody's individual machines.

It is vitally important that every user using the system has ALL file rights
to the FOLDER that the BE is stored in on the network. If they don't, only
one user will be able to be in the system at a time.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Tony Toews [MVP]]

I have been trying to figure this out for a few days now and I am stuck. I
am setting up an Access DB for work purposes. The user will enter data into
multiple forms within the DB, and this will happen in different sections of
the building at the same time. The problem I am having is that once I have
the DB open on one system, all other systems can only open in Read-Only and
cannot enter information unless they save a copy of the DB. I need the DB to
be able to be used dynamically by mulitple systems at the same time, with all
informaiton being stored in the original DB.

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
free Auto FE Updater utility at http://www.autofeupdater.com/ to make
the distribution of new FEs relatively painless.. The utility also
supports Terminal Server/Citrix quite nicely.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/