help with referencing second database please

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to refer to the file location of a second database to which i
wish to query data, by storing the name of the file and structure in a table
in the current database?

Where the query say 'c:\lims\lims\lims backup.mdb', i want somehow to
replace with a reference to a field and record in a table in the current
database

the current query is below


SELECT [Batches and Sample Identities1].[Batch Number], [Batches and Sample
Identities1].[Sample Identity], [Batches and Sample Identities1].[Sample
Number], [Batches and Sample Identities1].[Force Duplicate Analysis],
[Batches and Sample Identities1].[Force Spike Analysis], [Batches and Sample
Identities1].[Spike Std], [Batches and Sample Identities1].[Sample rejected],
[Batches and Sample Identities1].[Sample rejection reason], [Batches and
Sample Identities1].comments
FROM [Batches and Sample Identities1] IN 'c:\lims\lims\lims backup.mdb';
 
My guess is that there are several ways to do that. Probably easiest is
just defining a link (via File --> Get External Data --> Link Tables) to
the Table that you wish to access in the other database, and then using
the link as if it were an ordinary Table (except that you can't write to
it).

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
Back
Top