ashkumar
November 3rd, 2006, 10:29 AM
I'm getting data from two ACCESS database by the query below -
SELECT DISTINCT T1.*
FROM [c:\Database1.mdb].BILL AS T1, [c:\Database2.mdb].BILL AS T2
WHERE T1.BillNo & T1.Billdate IN(SELECT BillNo & Billdate FROM[c:\Database2.mdb].Bill);
I'm getting desired result & I've completed my application.
then I've set database password for security reason
but after setting the password my query doesn't work and
giving message "Invalid Password"
how can I Make password validation in the query ?????
Ashkumar
SELECT DISTINCT T1.*
FROM [c:\Database1.mdb].BILL AS T1, [c:\Database2.mdb].BILL AS T2
WHERE T1.BillNo & T1.Billdate IN(SELECT BillNo & Billdate FROM[c:\Database2.mdb].Bill);
I'm getting desired result & I've completed my application.
then I've set database password for security reason
but after setting the password my query doesn't work and
giving message "Invalid Password"
how can I Make password validation in the query ?????
Ashkumar