Saving the back-end with a new name

A

Alp Bekisoglu

Hi Experts,

I guess it should be possible to save the backend mdb with a new name to a
location from within the front-end. I would like to do it via VBA code.

Any pointers, help would highly be appreciated.

Thanks in advance,

Alp
 
R

Rick Brandt

Alp Bekisoglu said:
Hi Experts,

I guess it should be possible to save the backend mdb with a new name to a
location from within the front-end. I would like to do it via VBA code.

Any pointers, help would highly be appreciated.

Thanks in advance,
Click to expand...

As long as you have nothing active that is pulling data from the back end at the
time, just use FileCopy.

FileCopy "SourcePath" "DestinationPath"
 
A

Alp Bekisoglu

Hi Rick,

Thanks for your help and sorry for the late response.

One thing though, I wish it would remind/ask to overwrite... but does the
job anyway.

Alp
 
Top