I am trying to design a form from which a user can backup an mdb file to a
default location by clicking a command button. Can anybody give me some help
on the code to perform such an opperation?
Thanks in advance.

Hi,
you can use either a FileCopy, to make a copy, or CompactDatabase method to
make a copy and compact it

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


"Michalis J." <(E-Mail Removed)> wrote in message
news:C65FFA13-CE39-4177-B4AC-(E-Mail Removed)...
>I am trying to design a form from which a user can backup an mdb file to a
> default location by clicking a command button. Can anybody give me some
> help
> on the code to perform such an opperation?
> Thanks in advance.

I have an mdb that will backup any other mdb and even produce a log of its
acitivty. Download it at
www.dbtc.org/ftp/BackupCompactUtil.mdb

UpRider

"Michalis J." <(E-Mail Removed)> wrote in message
news:C65FFA13-CE39-4177-B4AC-(E-Mail Removed)...
>I am trying to design a form from which a user can backup an mdb file to a
> default location by clicking a command button. Can anybody give me some
> help
> on the code to perform such an opperation?
> Thanks in advance.