Database BackEnd Update???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim Tanis - 22 Apr 2005 15:30 GMT

I have a database split to BE & FE. Updating the FE is no problem, but I have
a problem updating the BE aka the table structure, as the database to be
updated has records.

I have a few things in mind:
Let's say the changes are made to an empty database (no records exist). Is
there a way to import the data from the working database to the new updated
BE in the corresponding tables (assuming the table names remain the same and
that only additions are made to tables)???

Any other workthroughs are more than welcome.

Reply to this Message

Jack MacDonald - 23 Apr 2005 15:38 GMT

If your BE is on your LAN, just open it directly, and make the changes
there.

If your BE is in a remote location, it's more difficult. Two
approaches:

- write a customized application that opens the BE and applies the
appropriate changes to the database via SQL or DAO. This is a method
that I use to support one remote application.

- try using a specialized program that allows you to "package" the
necessary changes and transmit them to the remote site. I dabbled with
a program called Backend Upgrader enough to become vaguely familiar
with its capabilities. Find it at:
http://www.databaseadvisors.com/downloads.htm

>I have a database split to BE & FE. Updating the FE is no problem, but I have
>a problem updating the BE aka the table structure, as the database to be
[quoted text clipped - 7 lines]
>
>Any other workthroughs are more than welcome.

**********************
jackmacMACdonald@telusTELUS.net
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security

Reply to this Message