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';
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';