Saving changes to access database in 2 different computers

[The Lone Ranger]

We have 5 computers in our small network, and they are
all "networked" together.

Can two people working on 2 different computers work on
an Access database at the same time? And can both their
changes be saved when they come out of the database?

Thank you.

 

[Kevin3NF]

Yes...depending on your versions of Access and whether you are referring to
data changes or development efforts.

Please explain more about your setup:

What version of Access?
Will the database be split? (do you know what split means?)
Will these changes be data-entry/edit, or developing?


--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

 

[mikepage5]

as long as they are not working on the same record.
Major errors can occur if you do not have the database
setup to prevent two people from accessing the same
record.

 

[Guest]

I have Access 2002 10.4302.4219. These would be simple
changes to data in the database table. I would like both
people to make changes, and both people's changes to save.

No, I don't know what "split" means. I'm sorry. This is
unchartered territory for me, but I love to learn!

I know NOTHING about developing!

 

[Kevin3NF]

In a split database environment, you have one Access database with nothing
but tables, which is located on a file share that all users can get to. You
then have a second Access database with everything BUT the tables (such as
forms, queries, reports, etc.). A copy of this database is located on each
user's hard drive, and has links to the the 1st db's tables.

As Mikepage5 said, as long as each user is not trying to change the same
record, you should be OK.

The database splitting is not nearly as hard as my description may make it
look. There's a wizard for it under Tools>>Database Utilities>>Database
Splitter. Try it out on a COPY of your db.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm