Need your advice

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe - 27 Apr 2004 15:38 GMT

I have my database in my regular computer, and would like
to transfer all my data to my Laptop.
What is the best way to transfer only the tables?

Every second weekend I will transfer all data to my
Laptop, and add/edit information during the weekend. And
the following Monday I will transfer all data back to my
regular computer.

The 2 computer will be connected via Local Network.

Thanks

Reply to this Message

Roger Carlson - 27 Apr 2004 15:57 GMT

First of all, the database should be split into a front-end (FE) and a
back-end (BE). The BE has only the tables and the FE has everything else
with the tables from the BE linked in. Then it is a simple matter to just
copy the tables.

If no one else is using the database, I would use some program like
PCAnywhere to synchronize the files. PCA will use file synchronization.

If others are using it and you want to merge your data with others, then use
Access Replication, which will synchronize the data at the record level.
Alison Balter has written several books that show how to do this.

Signature

--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

> I have my database in my regular computer, and would like
> to transfer all my data to my Laptop.
[quoted text clipped - 8 lines]
>
> Thanks

Reply to this Message

Joe - 27 Apr 2004 20:16 GMT

Hi, Roger

I have a single user application.
I would like to have 2 event buttons
1. to copy all tables form my Desktop to the Lap Top (on
Friday)
2. to copy all tables form my Lap Top to my Desktop (on
Sunday)

I already created the FE and BE.
Now I have 2 options.
1. Delete the BE file and copy it from the other computer
2. Delete all tables and insert it from the other computer

What is best?

Thanks

>-----Original Message-----
>First of all, the database should be split into a front-end (FE) and a
[quoted text clipped - 23 lines]
>
>.

Reply to this Message

Roger Carlson - 28 Apr 2004 15:42 GMT

I would copy the entire BE to the laptop and back again. VB has a FileCopy
command that will work if you can Share the drives. Otherwise, you'd have
to copy it up to the network on the desktop computer, then copy it down on
the laptop. As I said, I use PCAnywhere, although this still requires the
desktop to have a drive share.

Signature

--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

> I have my database in my regular computer, and would like
> to transfer all my data to my Laptop.
[quoted text clipped - 8 lines]
>
> Thanks

Reply to this Message

Joe - 29 Apr 2004 14:54 GMT

Roger,

I really appreciate your help

Actually I will connect the Lap Top to my desktop with a
network cable, and will not use any other network

Like use said, I'll only replace the BE file

If possible, I would like to have a button on a form that
will copy the BE file to the other location

Should I make a Macro?

Can you please help me with the commands?

Locations & Name of files
Computer name = MyDesktop
MyDesktop\\C:\MyProograms\BillingBE.MDB

Computer name = MyLapTop
MyLapTop\\C:\MyProograms\BillingBE.MDB

Thanks again
Joe

>-----Original Message-----
>I would copy the entire BE to the laptop and back again. VB has a FileCopy
[quoted text clipped - 17 lines]
>
>.

Reply to this Message