Put Button on form to move BE

[Jerry C]

I would ike to place a button on a form which will allow user to move
"Data.mdb" from current location to another location. Like from K: drive to
L: drive.

I realize that the FE will have to relink.
I have code in FE that will ask for location of BE if it can not be found on
original K: drive.
I have used DOS Move to make the move, but I want to do it with code in a
Button on my FE form.

 

[Jerry C]

To make things clearer:
FE is a MDE and opens exclusive.
Reason for move is Drive K: has become too slow and Drive L: on another
server has very little traffic.
The backup on servers is much better than on individule computers, otherwise
I would have data on same computer as FE.
I have code in FE to ask for new BE location and then link all the tables on
new BE location.

 

[John W. Vinson]

To make things clearer:
FE is a MDE and opens exclusive.
Reason for move is Drive K: has become too slow and Drive L: on another
server has very little traffic.
The backup on servers is much better than on individule computers, otherwise
I would have data on same computer as FE.
I have code in FE to ask for new BE location and then link all the tables on
new BE location.

Why do you feel that you need to do the move *from within the frontend*? Isn't
that a bit like replacing the transmission of a car... while the car is
running? I'd just use Windows Explorer or a .bat file to move it, then open
the frontend to do the relinking!

 

[Jerry C]

This app is running in about 40 locations and I am tired of talking users
thru the process. The example of moving BE from K: to L: is only the last
request.
Users have all kinds of reasons that they want to move BE.
Maybe they found out that another Access user had played with the data and
they want to move it so it's harder to find or maybe network it is on is not
being backed up often enough.
Some want to move data back to their own computer so they have total control.
Some want to put app on a laptop and take it home, so they can use it over
the weekend and then put data back on a server.
In other words the data is often on the move.

 

[Jerry C]

Thanks John
Creating a Bat file seems like the best solution.