By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,156 Members | 1,069 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,156 IT Pros & Developers. It's quick & easy.

Transferring files automatically

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.