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.

 

[Clifford Bass via AccessMonster.com]

Hi Jerry,

That seems to me like a dangerous thing to do. You will need to make
sure that no one else is accessing the data database, among other things.
And if any tables have been accessed in the BE from the FE, it will be opened
and there will be a lock file also. And Access will be expecting to find
those files in their current location because it is holding them open.
Probably you will need to have the process close out of the current database
and invoke some external process; maybe another Access database. That
external process would check to see if the BE is opened and if so, either
wait until it is not or fail. Only when the BE is closed would it do the
move. Your front end will need to have the automatic relinking code for the
next time it is fired up.

Perhaps someone already has coded this.

Good Luck,

Clifford Bass

 

[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.

 

[Clifford Bass via AccessMonster.com]

Hi Jerry,

Maybe I am missing something here. Why not just do the move manually
and be done with it?

Clifford Bass

 

[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.

 

[Clifford Bass via AccessMonster.com]

Hi Jerry,

That clarifies the issue. Although why anyone now-a-days cannot do a
simple drag and drop of files within Explorer or "My Computer" is a puzzle to
me. Here is my suggestion, which is a variation of John's suggestion and on
my earlier one. Instead of a button inside the current FE, create a separate
application to do the moving that the users will run separately while the
main application is not in use. Or, as an alternate to talking users through
it, point them to some Windows tutorial page that guides them through the
basics such as <http://www.geekgirls.com/absolute_beginners_06.htm>.

Clifford Bass

 

[Jerry C]

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