IMPORT FROM FLOPPY

[Peter D]

In my access 97 program i transfer my data in a DATA.mdb tot a floppy
( i know there are better ways, but tell that to my boss) So far no
problems.
But i would like a button on my program that i just click and the code
behind it reads my floppy and updates my records on another computer
with my program ( no we have not yet a network at the office).

If anyone know a simple code to read from a floppy and update the
records, I would welcome that help.

TX, anyone, anywhere, anyhow, anytime.

['69 Camaro]

Hi, Peter.

If anyone know a simple code to read from a floppy and update the
records, I would welcome that help.
Check out the TransferDatabase method in Access Help to transfer the entire
table to the database on the other computer. However, if you don't want to
replace the entire table in the other database, then you'll need to create a
query that identifies what records need to be updated and then update only
those fields that need to be changed.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
"Peter D" <da*********@pandora.be> wrote in message
news:2f**************************@posting.google.c om... In my access 97 program i transfer my data in a DATA.mdb tot a floppy
( i know there are better ways, but tell that to my boss) So far no
problems.
But i would like a button on my program that i just click and the code
behind it reads my floppy and updates my records on another computer
with my program ( no we have not yet a network at the office).

If anyone know a simple code to read from a floppy and update the
records, I would welcome that help.

TX, anyone, anywhere, anyhow, anytime.