[AccessD] SELECT IN using pw protected db.

Thanks to all for your input.  I had to get this stuff out fast so I ended
up just opening the external database with a database variable and then just
querying against that database.

I will probably go back and revisit this.

Sorry for the delay in getting back to you all, I took a few days off.

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly
Sent: Friday, May 27, 2005 1:59 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] SELECT IN using pw protected db.


hope this helps,

Set rs = cn.Execute("SELECT * FROM [ODBC;DSN={DSN Name};uid={User 
Name};pwd ={Password};database={Name of Database}].{Table in Database} 
WHERE FALSE")

One of these syntaxes may work

select * from customer in [ 'C:\Program Files\Microsoft 
Office\Office\Samples\Copy of Northwind.mdb';UID="Admin";PWD=""]

select * from customers in 'C:\Program Files\Microsoft 
Office\Office\Samples\Copy of Northwind.mdb'[uid="a"];

Bobby Heid wrote:

>Hey,
>
>I've done this before but can not seem to remember how at the moment.
>
>When I use:
>SELECT * 
>	FROM Version IN ';PWD=somepassword;DATABASE=D:\Wrap\WrapMrg\Merge
>5.04\Hudson.mdb;'
>
>I get a "Disk or Network error" error message.
>
>What am I doing wrong?
>
>Thanks,
>Bobby
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com