can I get 2 networked computers to use the same access database

S

Sandy Roman

Hi everyone,

Is it possible for two computers on the same network to use and make changes
to the same database?

I have recently added a network to my computer, connecting two computers
together. The database that I use for my small business was created years
ago. Now that I have one employee on my network, we both need to add and
delete information from the same database.

Is this possible and if so, how do I do it?

Thank you in advance.
 
J

John Vinson

On Mon, 31 Jan 2005 08:13:04 -0800, "Sandy Roman" <Sandy
Hi everyone,

Is it possible for two computers on the same network to use and make changes
to the same database?

I have recently added a network to my computer, connecting two computers
together. The database that I use for my small business was created years
ago. Now that I have one employee on my network, we both need to add and
delete information from the same database.

Is this possible and if so, how do I do it?

Thank you in advance.
Click to expand...

Possible, even routine.

I would strongly suggest using Tools... Database Utilities (or AddIns,
if you have A97 or older)... Database Splitter Wizard to split the
database into a "frontend" consisting of all the forms, reports,
queries etc. and a "backend" containing the tables. Each computer
should have its own copy of the frontend (and of the Access program),
both linked to the same backend.

John W. Vinson[MVP]
 
Top