link tables

[LCalaway]

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

[Larry Linson]

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" <re******@gte.net> wrote in message
news:B_Zwe.18245$rE6.2095@trnddc06...

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

[LCalaway]

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" <bo*****@localhost.not> wrote in message
news:Lv_we.24780$Ff6.20432@trnddc09...

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" <re******@gte.net> wrote in message
news:B_Zwe.18245$rE6.2095@trnddc06...

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

[Steven Zuch]

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" <re******@gte.net> wrote in message
news:B_Zwe.18245$rE6.2095@trnddc06...

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