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

B

babs

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
 
M

Melinda

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
 
B

babs

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
 
B

babs

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
 
J

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.
Click to expand...

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
 
M

Melinda

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!
 
Top