>Hi Cetin,
> Thanks for the reply. Now i have a problem cause when i used your code the system gave me an error telling me :
>
>OLE IDispatch exception code 0 from Microsoft JET Database Engine: You do not have the necessary permissions to use the 'C:\leaveTranfile.mde' object. Have your system administrator or the person who created this object establish the appropriate permissiion...
>
>How can i supply the ADO Connection with a username and password. Moreover the MDE file is using the file C:\securelog.mdw to information about the database security.
>
>Through ODBC is was simply passing the String :
>
>"...;SystemDB=C:\SecureLog.mdw;UID=leavelog;PWD=leavelogadmin"
>
>How can i obtain the same results using ADO Oledb.
>
>Thanks BeforeHand.
Oh I only kept it short. OLEDB provider also has many more properties :
'...;System database = '+;
'"C:\SecureLog.mdw";User ID=leavelog;Password="leavelogadmin"'
PS: I'm not sure about doublequotes. Try with and w/o them.
Cetin