Re: Linking Access databases (Jet SQL)
From: Robert Emmons (remmons_at_aurigen.com)
Date: 03/04/05
- Next message: John Friel: "Using Views that cause table updates."
- Previous message: Guillem: "Re: DbExpress Drive for .mdb???"
- In reply to: Jeremy Collins: "Linking Access databases (Jet SQL)"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Fri, 04 Mar 2005 10:03:00 -0500
On Thu, 03 Mar 2005 10:21:44 +0000, Jeremy Collins
<jd.collins@ntlworld-not.com> wrote:
>In Access, it's possible to query data from a table in another
>Access file, using this syntax:
>
>SELECT * FROM tb_table IN 'c:\folder\db_file.mdb'
>
>Does anyone have an example of how to provide the password for
>the second database? In my ADO connection string I'd use
>'Jet OLDDB:DatabasePassword=XYZ', but I can't figure out how to
>do it with Jet SQL.
This may not be the approach you want, but you can create a link to
the external table in the database which contains the query (primary
database). Then you open the primary database with a System.mdb file
which allows access to both databases. The query can then access the
external database withou any additional password, etc.
- Next message: John Friel: "Using Views that cause table updates."
- Previous message: Guillem: "Re: DbExpress Drive for .mdb???"
- In reply to: Jeremy Collins: "Linking Access databases (Jet SQL)"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
