Appending Databases

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a database that I can access on two or three computers simultaniously.

I've heard that you can share the same resource or something similar over a
network, which I'm unable to do with my current hardware set up.

I was wondering if there is a way in which I can take the same Access file,
on two or three computers in the following way;

Start the day with the exactly the same file. (copyied using usb flash drive)

Then add to each database during the day. (The information added to each one
will be unique.)

But then at the time of my business closing for the evening sticking the
access database from computer one and colaborating all the data, once the
file is on computer two?

therefore starting the next day with all of the prevous day's information on
all of the computers?

I hope you can all understand what I'm trying to do here.

I have heard that there are other ways in which to approach this task, if
you could explain them to me I would be most greatful, but fear that I might
not be able to acomplish some of these tasks using the hardware that I have.

I'm running what I believe to be a "full version" (It was a seperate
purchase to the rest of my Microsoft Office) of Access 2003 on all of the
computers.

Thankyou for your time, I would appreciate any help you can give me, as I
may have to invest in some form of network if I can't get it to work in this
way. (This way should also allow me to work from home)

Thankyou

Dan
 
I was wondering if there is a way in which I can take the same Access file,
on two or three computers in the following way;

Start the day with the exactly the same file. (copyied using usb flash drive)

Then add to each database during the day. (The information added to each one
will be unique.)

But then at the time of my business closing for the evening sticking the
access database from computer one and colaborating all the data, once the
file is on computer two?
Click to expand...

The term you want is "Replication". It's a complex process and not for
the faint of heart, but it's designed to do exactly what you describe.

See

http://support.microsoft.com/default.aspx?scid=kb;en-us;182886

for the Replication FAQ. Read it CAREFULLY; back up your database
before you start the process, it makes some major changes to all your
tables (for example, all Autonumber fields become Random).


John W. Vinson[MVP]
 
Thankyou, I have downloaded the FAQs file, but sound like what I needed.

Thankyou loads. (Bad English?)

Dan
 
Back
Top