How do I add a password to SQL?

E

Ed

SELECT tblOne.Contract
FROM tblOne IN 'D:\Database.mdb'

'D:\Database.mdb' has a password--
?--PWD='dirty'--

Ed
 
G

Gary Walter

"Ed" wrote
SELECT tblOne.Contract
FROM tblOne IN 'D:\Database.mdb'

'D:\Database.mdb' has a password--
?--PWD='dirty'--
Click to expand...
Hi Ed,


SELECT tblOne.Contract
FROM tblOne
IN '' <----this is 2 single quotes
[MS Access;PWD=dirty;DATABASE=D:\Database.mdb];

Gary Walter
 
Top