Joining two databases (with password)

[Jeremy Collins]

Hi all,

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 an ADO connection string I'd use
'Jet OLEDBatabasePassword=XYZ', but I can't figure out how to
do it with Jet SQL.

Cheers,

 

[Joseph Meehan]

Hi all,

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 an ADO connection string I'd use
'Jet OLEDBatabasePassword=XYZ', but I can't figure out how to
do it with Jet SQL.

Cheers,

Have you considered user level security?

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.

 

[Guest]

hi,
that should do it.
this is what i know as a remote query.
you can find out more at gary robinson's site.
http://www.vb123.com/toolshed/02_accvb/remotequeries.htm

 

[onedaywhen]

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 an ADO connection string I'd use
'Jet OLEDBatabasePassword=XYZ', but I can't figure out how to
do it with Jet SQL.

Try this:

SELECT * FROM
[MS Access;
c:\folder\db_file.mdb
;pwd=mypassword;].tb_table;

Jamie Collins.

--