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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

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

"Curtis Gray" wrote

> "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