more than 1 person enter data into the same form or table on netwo

[Guest]

HELP!! I am using Access 2000 & XP and need to have the database be out on
the server. However, by default can anyone open the database at the same
time and add data to it????? I need to be able to have the users add data to
the database - maybe not to the exact same form but at least to the same
database. Is there a need for them to hit refresh!!!! to make sure they are
looking at current data.

Please help - have not clue when dealing with access on a network,
permissions, or etc.
Thanks,
Barb

 

[Guest]

Barb,
You can split your database into two parts called the front end and back end
using the database splitter. It's found under Tools -> Database Utilities.
This will allow each of your users to have a copy of the front end on there
computer while the back end lives on the network. If you need further info
and guidance, feel free to search the news group (try searching for "multiple
users") for other people with problems relating to this.
Melinda

 

[Joseph Meehan]

HELP!! I am using Access 2000 & XP and need to have the database be out on
the server. However, by default can anyone open the database at the same
time and add data to it????? I need to be able to have the users add data
to
the database - maybe not to the exact same form but at least to the same
database. Is there a need for them to hit refresh!!!! to make sure they
are
looking at current data.

Please help - have not clue when dealing with access on a network,
permissions, or etc.
Thanks,
Barb

Yes, by default any user with normal LAN access to the folder where the
file is located will be able to open and edit any information in the
database and even make changes to the tables forms etc.

Most people find it is best to have a little more control over that
situation.

First suggestion is to split the database. The forms, queries, reports
are put on each user's machine. This will allow for less LAN traffic and
faster response time. The data itself is on the LAN in a database only
containing data that changes.

There are several ways of securing the database. Password access can
offer some protection, locking out most people without the password.
However real security comes in with user level security.

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can lock
everyone including God out.

Practice on some copies to make sure you know what you are doing.

Access has come good, but not great, tools to help with the traffic when
more than one person is editing the same data. That is called record
locking and you can look that up in the help file. In general when two
users are editing data that is in the same record (or a record close to that
one) it will tell the second person that someone else has changed the record
from what they were shown and offer them choices of how to go ahead.

Does that answer your first questions?

 

[Guest]

Thanks for the input- STILL NEED HELP! I went to tools database
utilities,database splitter. See it asks where to put the back end and asks
for a location but did not get prompted for where to put front end copies.
How do I put the front end copies out there. Right now I am at a stand alone
computer not on a network - would it have prompted me for the front end
locations if I was on a network!! I see arrows next to the tables (back end
-I am assuming??)
HELP!! Thanks so much

 

[Guest]

Melinda,
Thanks for your input. BUT STILL NEED HELP!!!
I did what you said with the database splitter. It prompted me on where to
put the backend of the database - did not prompt for front end copies. How
do I set up to put the front end copies at different locations. Once you help
me get the front end copies out does this mean that multiple people can add
to the forms, tables, queries at the same time. Will they see the data each
user is putting in to the same tables ,etc.

HELP Thanks

 

[Joseph Meehan]

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math

Melinda,
Thanks for your input. BUT STILL NEED HELP!!!
I did what you said with the database splitter. It prompted me on where
to
put the backend of the database - did not prompt for front end copies.
How
do I set up to put the front end copies at different locations. Once you
help
me get the front end copies out does this mean that multiple people can
add
to the forms, tables, queries at the same time.
Yes

Will they see the data each
user is putting in to the same tables ,etc.

Not until the first user as committed the data and the second user has
their data refreshed. This is generally handled by record locking, see my
other response.

 

[John Vinson]

Melinda,
Thanks for your input. BUT STILL NEED HELP!!!
I did what you said with the database splitter. It prompted me on where to
put the backend of the database - did not prompt for front end copies. How
do I set up to put the front end copies at different locations. Once you help
me get the front end copies out does this mean that multiple people can add
to the forms, tables, queries at the same time. Will they see the data each
user is putting in to the same tables ,etc.

The Splitter Wizard converts your .mdb file into two files - the
"backend", which has _BE appended to your filename, and the
"frontend", which retains the name of your starting database. This is
just a file on your computer - you can use Windows Explorer, or
MyComputer, or DOS Copy commands, to make as many copies of it as you
like, wherever you like. Each copy will be linked to the backend.

If you're on a network, you need to either be sure that everyone uses
the same drive letter for the folder containing the backend database,
or use the \\server\path\filename syntax rather than G:\path\filename
to ensure that everyone points to the right place.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Guest]

Barb,
You will know to go to each computer and put the front end on the computers.
I have found that it is easiest to put the front end and back end into a
folder on the network. Then using Windows Explorer copy the front end onto
each computer from those computers. Good luck!