[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