Click to See Complete Forum and Search --> : Problem with password validation


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