link tables

Hi, all

I have moved a backend/frontend database (2 mdb files) to a different
computer, a task done over and over in the past. The location on the second
computer has a different path name from the location on the former computer.

When I try to refresh the table links at the new location through the Linked
Table Manager, the window that appears that usually holds all of the names
of the tables to be refreshed, is totally empty. Of course, I can't link
anything.

Manually deleting and relinking the tables in the frontend is possible, but
painful as a final solution every time. Any suggetions to troubleshooting
this one would be appreciated.

LCalaway

re: link tables

VBA Code?

All tables are in the Tables Collection, and, my recollection is that there
is pretty good Help on using it. Of course, if you are running Access 2003,
there are some who would argue that none of its "online primary" Help is
very good.

That's what I used to do back when I worked on an Access client to Informix,
to convert a Development database into a Production database for
distribution. Of course, for that situation, you had to delete the TableDef
and create a new TableDef, but it wasn't a big problem.

Matter of fact, isn't there code in the Solutions.MDB sample database for
re-linking tables? Visit the Knowledge Base at
http://support.microsoft.com/default...b;en-us;248674 for download
instructions. (Or search for Knowledge Base article 248674.

Larry Linson
Microsoft Access MVP


"LCalaway" <res0056r@gte.net> wrote in message
news:B_Zwe.18245$rE6.2095@trnddc06...[color=blue]
> Hi, all
>
> I have moved a backend/frontend database (2 mdb files) to a different
> computer, a task done over and over in the past. The location on the[/color]
second[color=blue]
> computer has a different path name from the location on the former[/color]
computer.[color=blue]
>
> When I try to refresh the table links at the new location through the[/color]
Linked[color=blue]
> Table Manager, the window that appears that usually holds all of the names
> of the tables to be refreshed, is totally empty. Of course, I can't link
> anything.
>
> Manually deleting and relinking the tables in the frontend is possible,[/color]
but[color=blue]
> painful as a final solution every time. Any suggetions to troubleshooting
> this one would be appreciated.
>
> LCalaway
>
>[/color]

re: link tables

My question has to do with why the container, while using the Linking
Wizard, is completely empty when it should list the tables that need to be
refreshed to the newly relocated backend.

There is a BUG - reported in article 835519. Unfortunately the suggestions
there don't work.

Am looking for other help if anyone has seen this before.

Thanks
LCalaway


"Larry Linson" <bouncer@localhost.not> wrote in message
news:Lv_we.24780$Ff6.20432@trnddc09...[color=blue]
> VBA Code?
>
> All tables are in the Tables Collection, and, my recollection is that
> there
> is pretty good Help on using it. Of course, if you are running Access
> 2003,
> there are some who would argue that none of its "online primary" Help is
> very good.
>
> That's what I used to do back when I worked on an Access client to
> Informix,
> to convert a Development database into a Production database for
> distribution. Of course, for that situation, you had to delete the
> TableDef
> and create a new TableDef, but it wasn't a big problem.
>
> Matter of fact, isn't there code in the Solutions.MDB sample database for
> re-linking tables? Visit the Knowledge Base at
> http://support.microsoft.com/default...b;en-us;248674 for
> download
> instructions. (Or search for Knowledge Base article 248674.
>
> Larry Linson
> Microsoft Access MVP
>
>
> "LCalaway" <res0056r@gte.net> wrote in message
> news:B_Zwe.18245$rE6.2095@trnddc06...[color=green]
>> Hi, all
>>
>> I have moved a backend/frontend database (2 mdb files) to a different
>> computer, a task done over and over in the past. The location on the[/color]
> second[color=green]
>> computer has a different path name from the location on the former[/color]
> computer.[color=green]
>>
>> When I try to refresh the table links at the new location through the[/color]
> Linked[color=green]
>> Table Manager, the window that appears that usually holds all of the
>> names
>> of the tables to be refreshed, is totally empty. Of course, I can't link
>> anything.
>>
>> Manually deleting and relinking the tables in the frontend is possible,[/color]
> but[color=green]
>> painful as a final solution every time. Any suggetions to troubleshooting
>> this one would be appreciated.
>>
>> LCalaway
>>
>>[/color]
>
>[/color]

re: link tables

Sample DAO Code (located in frontend database)
======================================

Sub AttachTablesSample()

Dim Db As Database, Td As TableDef
Dim N As Integer, T As Integer

Const MdbName = "x:\foldername\backend.mdb" '** Full name of backend
database **"

Set Db = CurrentDb
T = Db.TableDefs.Count

For N = 0 To T - 1
Set Td = Db.TableDefs(N)
If Td.Connect <> "" Then
Td.Connect = ";DATABASE=" & MdbName
Td.RefreshLink
End If
Next N
Set Db = Nothing

End Sub


Code only links tables which already have been linked to the backend
database (e.g. ignores tables located in the frontend database).

Clearly, if you wanted the user to be able to specify the backend file name,
error trapping is required.

Steven R. Zuch, CPA
Cogent Management Inc.


"LCalaway" <res0056r@gte.net> wrote in message
news:B_Zwe.18245$rE6.2095@trnddc06...[color=blue]
> Hi, all
>
> I have moved a backend/frontend database (2 mdb files) to a different
> computer, a task done over and over in the past. The location on the
> second computer has a different path name from the location on the former
> computer.
>
> When I try to refresh the table links at the new location through the
> Linked Table Manager, the window that appears that usually holds all of
> the names of the tables to be refreshed, is totally empty. Of course, I
> can't link anything.
>
> Manually deleting and relinking the tables in the frontend is possible,
> but painful as a final solution every time. Any suggetions to
> troubleshooting this one would be appreciated.
>
> LCalaway
>[/color]