Transferring files automatically

[Brian]

I'm trying to figure out a way to automatically transfer the entire
back end db folder from a laptop to a network drive so it can be read
by another user. I need to overwrite the existing folder in I:\ with
the C:\ folder. The folder contains linked photos along with the back
end db. I can back up just the db by calling the following from the
autoexex macro:

Kill "I:\backend_db.mdb"

DBEngine.CompactDatabase "C:\backend_db.mdb", "I:\backend_db.mdb"

which works great, but obviously doesn't do anything with the jpeg
files within the folder. Any suggestions would be appreciated.
Thanks in advance.

Brian

[Douglas J. Steele]

You could create a batch file that invokes does something like

COPY C:\*.jpg I:

and use Shell to run it.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)

"Brian" <br************@ci.verona.wi.us> wrote in message
news:21**************************@posting.google.c om...

I'm trying to figure out a way to automatically transfer the entire
back end db folder from a laptop to a network drive so it can be read
by another user. I need to overwrite the existing folder in I:\ with
the C:\ folder. The folder contains linked photos along with the back
end db. I can back up just the db by calling the following from the
autoexex macro:

Kill "I:\backend_db.mdb"

DBEngine.CompactDatabase "C:\backend_db.mdb", "I:\backend_db.mdb"

which works great, but obviously doesn't do anything with the jpeg
files within the folder. Any suggestions would be appreciated.
Thanks in advance.

Brian