Copy DB to alternate Dir

G

Guest

I am using the code found at http://www.mvps.org/access/api/api0026.htm but
need the db copied to a different directory. My novicity led me to change the
code from
strSaveFile = CurrentDb.Name
to
strSaveFile = "path\dbname.mdb"
I received a System error concerning a place in memory not being able to be
read and couldn't get the app to run again, even when replacing the original
code, until I did a cold boot.
Any ideas?
TIA!
 
G

Guest

Have you tried using the
FSO.Copyfile command
ex
FSO.Copyfile "source file name" "destination file name"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to run a module? 4
Using UNC path when reconnecting tables 1
Retrieve just the file name, not the full path 3
Tweek code to give just the path 2
I want to attach an Excel file on the Access Form 2
temp db 1
Save File API 1
Insert UserID after copy 1

Top