data entry in multiuser environment.

[sleeperjjb]

I have a database that is shared across a network drive. I need multiple
people to be able to open, and enter data in a form at the same time and save
their work. Is it possible for concurrent saves in an access database? Does
splitting the database into a back end and front end allow multiple users to
save in a form at the same time?

 

[boblarson]

Yes, the database should be split. The frontend should be set so that EACH
user has a copy on their machine. See here for more about splitting:
http://www.members.shaw.ca/AlbertKallal/Articles/split/


And if you use my Frontend Auto Update Enabling tool, it will enable you to
do auto updates of your frontends. Yes, the first distribution you will need
to get it to people somehow and that is in your court. But, if you have
enabled auto updating, then you can just go into your master file on the
network, make your changes, change the version number in two tables (one in
the frontend and one in the frontend that is linked to the backend), then
when your users open their frontend and the version numbers don't match it
will tell them that their frontend is out-of-date and it will close, delete
the old file, copy the new file, and then reopen for them automatically.

I had to create this for a big healthcare provider I worked for which
originally had over 100 users using a single mdb frontend on the server and
they wondered why it crashed each week, or several times each week. So, once
we implemented this and moved to frontends on each user's machine, they never
had a corruption issue again as long as I was there.

You can download it here:

http://www.btabdevelopment.com/main/MyFreeAccessTools/tabid/78/Default.aspx


--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[sleeperjjb]

Could i run into a problem with users having older versions of access and
trying to open my FE access 2000 version file?

 

[Klatuu]

Yes. But, if you develop the fe and be in the oldest version, the newer
versions will have no problem with it.

 

[sleeperjjb]

I split the database into a FE and BE but then needed to add a new table. I
assumed that i create it in the BE but when i open the FE it doesn't show up
and when i run linked table manager and refresh it, the new table still
doesn't show up. How do you create new tables in the BE and have them linked
in the FE

 

[John W. Vinson/MVP]

I split the database into a FE and BE but then needed to add a new table. I
assumed that i create it in the BE but when i open the FE it doesn't show
up
and when i run linked table manager and refresh it, the new table still
doesn't show up. How do you create new tables in the BE and have them
linked
in the FE

The linked table manager only refreshes tables which are already linked -
not new ones. To include a new table, open the frontend and use File... Get
External Data... Link to find and connect to the new table. Then distribute
the new frontend to the users (frontends contain no data so they can be
safely just destroyed and replaced as needed).