Desire to REMERGE Database and Program!!

[John Baker]

Hi:

Some time ago I developed a program in Access, and separated the database and the program
itself (using the normal access tools).We have the db on our server and the programin the
desktop system. I have modified the program a number of times, and now find that I need
to change the DB slightlt. This appears to require that I REMERGE the data base and
program, and I have no idea how to do that.

Can someone give me some pointers, since the help package is of NO help with this!

Regards

John Baker

[Peter Miller]

Re: Desire to REMERGE Database and Program!!


On Wed, 12 Nov 2003 16:04:12 GMT, John Baker <Baker.JH@Veriz on.net>
wrote in comp.databases. ms-access:
[color=blue]
>Some time ago I developed a program in Access, and separated the database and the program
>itself (using the normal access tools).We have the db on our server and the programin the
>desktop system.[/color]

Good for you.
[color=blue]
>I have modified the program a number of times, and now find that I need
>to change the DB slightlt.[/color]

This is not at all unusual.
[color=blue]
>This appears to require that I REMERGE the data base and
>program, and I have no idea how to do that.[/color]

No - it requires no such thing.
[color=blue]
>Can someone give me some pointers, since the help package is of NO help with this![/color]

The 'help package' has no help on this because there is no good reason
for such a thing to be required. Why exactly do you believe you must
remerge the files, losing the benefits of separate fe/be deployment,
and going against the good advice of developers and Msft to split
application and data files - good advice that you have already
followed?


Peter Miller
_______________ _______________ _______________ _______________
PK Solutions -- Data Recovery for Microsoft Access/Jet/SQL
Free quotes, Guaranteed lowest prices and best results
www.pksolutions.com 1.866.FILE.FIX 1.760.476.9051

[Terry Kreft]

Re: Desire to REMERGE Database and Program!!

John,
Why would you need to re-merge the program? I can't think of any reason why
you would need to.

The straightforward way to do it though would be to clear all the linked
tables in the front end and then import the tables from the back end.

Terry


"John Baker" <Baker.JH@Veriz on.net> wrote in message
news:0em4rv4nk9 mtqqbcr4dps9i9l 7t4lgo9u3@4ax.c om...[color=blue]
> Hi:
>
> Some time ago I developed a program in Access, and separated the database[/color]
and the program[color=blue]
> itself (using the normal access tools).We have the db on our server and[/color]
the programin the[color=blue]
> desktop system. I have modified the program a number of times, and now[/color]
find that I need[color=blue]
> to change the DB slightlt. This appears to require that I REMERGE the data[/color]
base and[color=blue]
> program, and I have no idea how to do that.
>
> Can someone give me some pointers, since the help package is of NO help[/color]
with this![color=blue]
>
> Regards
>
> John Baker[/color]

[Fredg]

Re: Desire to REMERGE Database and Program!!

John,
I think what your saying is that you split the database into a Front end
(forms, queries, reports) and a Back end (tables) and now want to return the
tables to the current back end.

Make a Back Up copy of the Back end first.

Open the Front end database (with the Forms, Queries, etc.).
Delete the linked tables (the linked tables will have an arrow next to them
showing they are linked). If there is no arrow, then that table resides on
the Front end and should NOT be deleted.
Don't worry, you are not deleting the tables in the Back end, just the links
between the Front and Back ends.

Once the linked tables are deleted, click File + Get External Data + Import
Follow the wizard and import the tables definition and data, and
relationships, from the Back end.

That should be all you need.
Make sure the relationships are correct.

The former Back end still contains the original tables and data.
The former Front end now contains everything and is no longer linked to the
old Back end.
--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.


"John Baker" <Baker.JH@Veriz on.net> wrote in message
news:0em4rv4nk9 mtqqbcr4dps9i9l 7t4lgo9u3@4ax.c om...[color=blue]
> Hi:
>
> Some time ago I developed a program in Access, and separated the database[/color]
and the program[color=blue]
> itself (using the normal access tools).We have the db on our server and[/color]
the programin the[color=blue]
> desktop system. I have modified the program a number of times, and now[/color]
find that I need[color=blue]
> to change the DB slightlt. This appears to require that I REMERGE the data[/color]
base and[color=blue]
> program, and I have no idea how to do that.
>
> Can someone give me some pointers, since the help package is of NO help[/color]
with this![color=blue]
>
> Regards
>
> John Baker[/color]

[Heather]

Re: Desire to REMERGE Database and Program!!

Terry,

How would you clear all the linked tables in the front end and then import the
tables from the back end with code?

Thanks!

Heather


"Terry Kreft" <terry.kreft@mp s.co.uk> wrote in message
news:botoiq$v22 $1@newsreaderg1 .core.theplanet .net...[color=blue]
> John,
> Why would you need to re-merge the program? I can't think of any reason why
> you would need to.
>
> The straightforward way to do it though would be to clear all the linked
> tables in the front end and then import the tables from the back end.
>
> Terry
>
>
> "John Baker" <Baker.JH@Veriz on.net> wrote in message
> news:0em4rv4nk9 mtqqbcr4dps9i9l 7t4lgo9u3@4ax.c om...[color=green]
> > Hi:
> >
> > Some time ago I developed a program in Access, and separated the database[/color]
> and the program[color=green]
> > itself (using the normal access tools).We have the db on our server and[/color]
> the programin the[color=green]
> > desktop system. I have modified the program a number of times, and now[/color]
> find that I need[color=green]
> > to change the DB slightlt. This appears to require that I REMERGE the data[/color]
> base and[color=green]
> > program, and I have no idea how to do that.
> >
> > Can someone give me some pointers, since the help package is of NO help[/color]
> with this![color=green]
> >
> > Regards
> >
> > John Baker[/color]
>
>[/color]

[Heather]

Re: Desire to REMERGE Database and Program!!

Fred,

How would you do all you say with code?

Thanks!

Heather


"Fredg" <fgutkind@examp le.invalid> wrote in message
news:dPtsb.2432 86$0v4.17118771 @bgtnsc04-news.ops.worldn et.att.net...[color=blue]
> John,
> I think what your saying is that you split the database into a Front end
> (forms, queries, reports) and a Back end (tables) and now want to return the
> tables to the current back end.
>
> Make a Back Up copy of the Back end first.
>
> Open the Front end database (with the Forms, Queries, etc.).
> Delete the linked tables (the linked tables will have an arrow next to them
> showing they are linked). If there is no arrow, then that table resides on
> the Front end and should NOT be deleted.
> Don't worry, you are not deleting the tables in the Back end, just the links
> between the Front and Back ends.
>
> Once the linked tables are deleted, click File + Get External Data + Import
> Follow the wizard and import the tables definition and data, and
> relationships, from the Back end.
>
> That should be all you need.
> Make sure the relationships are correct.
>
> The former Back end still contains the original tables and data.
> The former Front end now contains everything and is no longer linked to the
> old Back end.
> --
> Fred
>
> Please reply only to this newsgroup.
> I do not reply to personal e-mail.
>
>
> "John Baker" <Baker.JH@Veriz on.net> wrote in message
> news:0em4rv4nk9 mtqqbcr4dps9i9l 7t4lgo9u3@4ax.c om...[color=green]
> > Hi:
> >
> > Some time ago I developed a program in Access, and separated the database[/color]
> and the program[color=green]
> > itself (using the normal access tools).We have the db on our server and[/color]
> the programin the[color=green]
> > desktop system. I have modified the program a number of times, and now[/color]
> find that I need[color=green]
> > to change the DB slightlt. This appears to require that I REMERGE the data[/color]
> base and[color=green]
> > program, and I have no idea how to do that.
> >
> > Can someone give me some pointers, since the help package is of NO help[/color]
> with this![color=green]
> >
> > Regards
> >
> > John Baker[/color]
>
>[/color]

[John Baker]

Re: Desire to REMERGE Database and Program!!

Peter:

The response I get when I try and open the Tables in design mode implies that I cant
change all the characteristic of the db through design mode when I am working with a
linked table. I assumed I had to recombine somehow to change the db itself.

The way this has worked is that I have a copy of the db and the program files (seperated)
on my system at home, and use that for development etc. When updates are required for the
programs, I make the changes on my home system, copy the programs section (only) into a cd
and then copy it into the local systems at work. I then change the linkage to point to the
server db and we are off and running.

I gather this is the correct thing to do!

Regards

John Baker

Peter Miller <pmiller@pksolu tions.com> wrote:
[color=blue]
>
>On Wed, 12 Nov 2003 16:04:12 GMT, John Baker <Baker.JH@Veriz on.net>
>wrote in comp.databases. ms-access:
>[color=green]
>>Some time ago I developed a program in Access, and separated the database and the program
>>itself (using the normal access tools).We have the db on our server and the programin the
>>desktop system.[/color]
>
>Good for you.
>[color=green]
>>I have modified the program a number of times, and now find that I need
>>to change the DB slightlt.[/color]
>
>This is not at all unusual.
>[color=green]
>>This appears to require that I REMERGE the data base and
>>program, and I have no idea how to do that.[/color]
>
>No - it requires no such thing.
>[color=green]
>>Can someone give me some pointers, since the help package is of NO help with this![/color]
>
>The 'help package' has no help on this because there is no good reason
>for such a thing to be required. Why exactly do you believe you must
>remerge the files, losing the benefits of separate fe/be deployment,
>and going against the good advice of developers and Msft to split
>application and data files - good advice that you have already
>followed?
>
>
>Peter Miller
>______________ _______________ _______________ _______________ _
> PK Solutions -- Data Recovery for Microsoft Access/Jet/SQL
> Free quotes, Guaranteed lowest prices and best results
> www.pksolutions.com 1.866.FILE.FIX 1.760.476.9051[/color]

[Fredg]

Re: Desire to REMERGE Database and Program!!

Heather,
Why would you want to take the time to write and debug the code, when doing
it manually would take less than 5 minutes?

If you still want to bother, search

http://www.groups.google.com

for back posts on this.

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.


"Heather" <hamonroe@csedu cationalsystems .org> wrote in message
news:pVtsb.2539 2$9M3.11407@new sread2.news.atl .earthlink.net. ..[color=blue]
> Fred,
>
> How would you do all you say with code?
>
> Thanks!
>
> Heather[/color]
** snipped **

[paii, Ron]

Re: Desire to REMERGE Database and Program!!

Open the backend database and change the table structure. The changes will
be reflected in the front end links.

Close all front ends 1st.

"John Baker" <Baker.JH@Veriz on.net> wrote in message
news:pos4rvc6kv ou7s187cghgsh7u o78s2oo95@4ax.c om...[color=blue]
> Peter:
>
> The response I get when I try and open the Tables in design mode implies[/color]
that I cant[color=blue]
> change all the characteristic of the db through design mode when I am[/color]
working with a[color=blue]
> linked table. I assumed I had to recombine somehow to change the db[/color]
itself.[color=blue]
>
> The way this has worked is that I have a copy of the db and the program[/color]
files (seperated)[color=blue]
> on my system at home, and use that for development etc. When updates are[/color]
required for the[color=blue]
> programs, I make the changes on my home system, copy the programs section[/color]
(only) into a cd[color=blue]
> and then copy it into the local systems at work. I then change the linkage[/color]
to point to the[color=blue]
> server db and we are off and running.
>
> I gather this is the correct thing to do!
>
> Regards
>
> John Baker
>
> Peter Miller <pmiller@pksolu tions.com> wrote:
>[color=green]
> >
> >On Wed, 12 Nov 2003 16:04:12 GMT, John Baker <Baker.JH@Veriz on.net>
> >wrote in comp.databases. ms-access:
> >[color=darkred]
> >>Some time ago I developed a program in Access, and separated the[/color][/color][/color]
database and the program[color=blue][color=green][color=darkred]
> >>itself (using the normal access tools).We have the db on our server and[/color][/color][/color]
the programin the[color=blue][color=green][color=darkred]
> >>desktop system.[/color]
> >
> >Good for you.
> >[color=darkred]
> >>I have modified the program a number of times, and now find that I need
> >>to change the DB slightlt.[/color]
> >
> >This is not at all unusual.
> >[color=darkred]
> >>This appears to require that I REMERGE the data base and
> >>program, and I have no idea how to do that.[/color]
> >
> >No - it requires no such thing.
> >[color=darkred]
> >>Can someone give me some pointers, since the help package is of NO help[/color][/color][/color]
with this![color=blue][color=green]
> >
> >The 'help package' has no help on this because there is no good reason
> >for such a thing to be required. Why exactly do you believe you must
> >remerge the files, losing the benefits of separate fe/be deployment,
> >and going against the good advice of developers and Msft to split
> >application and data files - good advice that you have already
> >followed?
> >
> >
> >Peter Miller
> >______________ _______________ _______________ _______________ _
> > PK Solutions -- Data Recovery for Microsoft Access/Jet/SQL
> > Free quotes, Guaranteed lowest prices and best results
> > www.pksolutions.com 1.866.FILE.FIX 1.760.476.9051[/color]
>[/color]

[Heather]

Re: Desire to REMERGE Database and Program!!

Fred,

I have a central split database maintained by two admins. I'm going to need to
need to send a copy of the database to six remote sites monthly on CD. Via code
I would like to merge the FE and BE and then copy to CD. This makes copying to
CD easier but more so makes the installation at the remote sites simpler. I want
to include the FE each month so that if changes are ever made to the central
database they will be included in the monthly distributions. The need is for
push button operation for the admins and especially for the remote sites.

Heather


"Fredg" <fgutkind@examp le.invalid> wrote in message
news:ZAusb.2435 11$0v4.17122512 @bgtnsc04-news.ops.worldn et.att.net...[color=blue]
> Heather,
> Why would you want to take the time to write and debug the code, when doing
> it manually would take less than 5 minutes?
>
> If you still want to bother, search
> http://www.groups.google.com
>
> for back posts on this.
>
> --
> Fred
>
> Please reply only to this newsgroup.
> I do not reply to personal e-mail.
>
>
> "Heather" <hamonroe@csedu cationalsystems .org> wrote in message
> news:pVtsb.2539 2$9M3.11407@new sread2.news.atl .earthlink.net. ..[color=green]
> > Fred,
> >
> > How would you do all you say with code?
> >
> > Thanks!
> >
> > Heather[/color]
> ** snipped **
>
>[/color]

[Rick Brandt]

Re: Desire to REMERGE Database and Program!!

"paii, Ron" <paii@packairin c.com> wrote in message
news:vr4ubm30jb cce@corp.supern ews.com...[color=blue]
> Open the backend database and change the table structure. The changes[/color]
will[color=blue]
> be reflected in the front end links.[/color]

Not until you refresh the links though.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[David W. Fenton]

Re: Desire to REMERGE Database and Program!!

hamonroe@cseduc ationalsystems. org (Heather) wrote in
<eXusb.25483$9M 3.24549@newsrea d2.news.atl.ear thlink.net>:
[color=blue]
>I have a central split database maintained by two admins. I'm
>going to need to need to send a copy of the database to six remote
>sites monthly on CD. Via code I would like to merge the FE and BE
>and then copy to CD. This makes copying to CD easier but more so
>makes the installation at the remote sites simpler. I want to
>include the FE each month so that if changes are ever made to the
>central database they will be included in the monthly
>distribution s. The need is for push button operation for the
>admins and especially for the remote sites.[/color]

Ok, now, the following is little more than air code (written in
Access, but not tested). It gives you the basic structure you need,
though it's probably got some problems in it:

Public Sub DeleteLinkedTab les()
Dim db As Database
Dim tdf As TableDef

Set db = CurrentDb()
For Each tdf In db.TableDefs
If Len(tdf.Connect & vbNullString) <> 0 Then
db.TableDefs.De lete (tdf.Name)
End If
Next tdf

Set tdf = Nothing
Set db = Nothing
End Sub

Public Sub ImportTables(st rDB As String)
Dim db As Database
Dim tdf As TableDef
Dim strTable As String

Set db = DBEngine.OpenDa tabase(strDB)
For Each tdf In db.TableDefs
If Len(tdf.Connect & vbNullString) <> 0 Then
strTable = tdf.Name
DoCmd.TransferD atabase acImport, , strDB, acTable,
strTable, strTable
End If
Next tdf

Set tdf = Nothing
db.Close
Set db = Nothing
End Sub

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[Peter Miller]

Re: Desire to REMERGE Database and Program!!


On Wed, 12 Nov 2003 17:53:44 GMT, John Baker <Baker.JH@Veriz on.net>
wrote in comp.databases. ms-access:
[color=blue]
>The response I get when I try and open the Tables in design mode implies that I cant
>change all the characteristic of the db through design mode when I am working with a
>linked table.[/color]

That is correct. If you want to change table characteristics , you
need to do this on the tables - not on the links. As Ron indicated in
his follow-up, make table changes to the backend, and code/visual
design changes to the front-end. Relink the tables in the FE once the
BE table changes are made.
[color=blue]
> I assumed I had to recombine somehow to change the db itself.[/color]

No. Not at all. Not only is that way more work than necessary, but
it is counterproducti ve. Leave the files split and just make the
table changes in the second file, where they belong.
[color=blue]
>The way this has worked is that I have a copy of the db and the program files (seperated)
>on my system at home, and use that for development etc. When updates are required for the
>programs, I make the changes on my home system, copy the programs section (only) into a cd
>and then copy it into the local systems at work. I then change the linkage to point to the
>server db and we are off and running.
>
>I gather this is the correct thing to do![/color]

Yes, but you'll also want to make the backend changes to the data file
at work too. If the db is not in use when you're away from the
office, you could just copy your modified backend (along with
frontend) back onto the work systems, but if the file IS in use at
work while you're away, then you will want to make the backend mods
directly to the backend when back at work rather than overwriting the
backend.


Peter Miller
_______________ _______________ _______________ _______________
PK Solutions -- Data Recovery for Microsoft Access/Jet/SQL
Free quotes, Guaranteed lowest prices and best results
www.pksolutions.com 1.866.FILE.FIX 1.760.476.9051

[Heather]

Re: Desire to REMERGE Database and Program!!

Thank You!

Heather


"David W. Fenton" <dXXXfenton@bwa y.net.invalid> wrote in message
news:94318ACA5d fentonbwaynetin vali@24.168.128 .86...[color=blue]
> hamonroe@cseduc ationalsystems. org (Heather) wrote in
> <eXusb.25483$9M 3.24549@newsrea d2.news.atl.ear thlink.net>:
>[color=green]
> >I have a central split database maintained by two admins. I'm
> >going to need to need to send a copy of the database to six remote
> >sites monthly on CD. Via code I would like to merge the FE and BE
> >and then copy to CD. This makes copying to CD easier but more so
> >makes the installation at the remote sites simpler. I want to
> >include the FE each month so that if changes are ever made to the
> >central database they will be included in the monthly
> >distribution s. The need is for push button operation for the
> >admins and especially for the remote sites.[/color]
>
> Ok, now, the following is little more than air code (written in
> Access, but not tested). It gives you the basic structure you need,
> though it's probably got some problems in it:
>
> Public Sub DeleteLinkedTab les()
> Dim db As Database
> Dim tdf As TableDef
>
> Set db = CurrentDb()
> For Each tdf In db.TableDefs
> If Len(tdf.Connect & vbNullString) <> 0 Then
> db.TableDefs.De lete (tdf.Name)
> End If
> Next tdf
>
> Set tdf = Nothing
> Set db = Nothing
> End Sub
>
> Public Sub ImportTables(st rDB As String)
> Dim db As Database
> Dim tdf As TableDef
> Dim strTable As String
>
> Set db = DBEngine.OpenDa tabase(strDB)
> For Each tdf In db.TableDefs
> If Len(tdf.Connect & vbNullString) <> 0 Then
> strTable = tdf.Name
> DoCmd.TransferD atabase acImport, , strDB, acTable,
> strTable, strTable
> End If
> Next tdf
>
> Set tdf = Nothing
> db.Close
> Set db = Nothing
> End Sub
>
> --
> David W. Fenton http://www.bway.net/~dfenton
> dfenton at bway dot net http://www.bway.net/~dfassoc[/color]

[Peter Miller]

Re: Desire to REMERGE Database and Program!!

On Wed, 12 Nov 2003 12:54:21 -0600, "Rick Brandt"
<rickbrandt2@ho tmail.com> wrote in comp.databases. ms-access:
[color=blue]
>Not until you refresh the links though.[/color]

Absolutely. Corruption can occur if a fe with old links is used to
access data with modified structures. It won't always occur, but it
*can* and *does* occur at times. Refreshing links when table
definitions change is VERY important.

Peter Miller
_______________ _______________ _______________ _______________
PK Solutions -- Data Recovery for Microsoft Access/Jet/SQL
Free quotes, Guaranteed lowest prices and best results
www.pksolutions.com 1.866.FILE.FIX 1.760.476.9051