Derive or recreate table format from link info?

[Curtis Gray]

Is it possible to derive or recreate a table format based on linked
table information? In other words, does Access store table format
information for linked tables? If so, how can I get at it.

I need to recreate a set of tables and the linked tables are no longer
available.

Please help.

Curtis

 

[Jeff Boyce]

Curtis

"no longer available" might mean "no longer linked into my database", or
"not there, but still showing as linked".

If the linked tables are still showing, have you tried opening them in
design mode and copying the table definition, then creating a new table and
pasting in the definition?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Curtis Gray]

Hi Jeff,

"not there, but still showing as linked" is about the closest to the
situation.

I have an application that uses an external MDB database for its
tables. The local database is composed of linked table definitions to
the external database. The external database is no longer available. I
need to recreate that external database from scratch and was hoping
there was a way to derive the table definitions from the local database
somehow.

Curtis

 

[Larry Linson]

"not there, but still showing as linked" is
about the closest to the situation.

I have an application that uses an external
MDB database for its tables. The local
database is composed of linked table defi-
nitions to the external database. The external
database is no longer available. I need to
recreate that external database from scratch
and was hoping there was a way to derive
the table definitions from the local database
somehow.

The link indicates how to get to the table (which you've said, is no longer
there), that is, its location, the type of table, and perhaps userid and
password -- the details of the table itself are "Gone with the TableDefs" in
that external database which is no longer there.

You may be able, with some effort, to re-construct the tables from the way
they are/were used in Queries, Reports, Forms, and maybe Modules.

I have, at times, put "Template" tables, empty of data, in the Front End,
and an option to create a new "datastore" or database with Tables for
linking. But, I've only done that in demos... it's not a widespread
practice, and not a regular practice even for me.

Larry Linson
Microsoft Access MVP