Saving the back-end with a new name

[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

 

[Rick Brandt]

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,

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

FileCopy "SourcePath" "DestinationPath"

 

[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