How do I add a password to SQL?

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

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

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

Ed
 
"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
 
Back
Top