Access 2010: How to Dmax from linked table - Password protected

[lynxbci]

Hi,

My Db has a linked table, to another Db that is password encrypted. When i try and use the following code

mx_Check = DMax("MatrixNo", "Matrixresults", "rollno = " & [txt_po])

I get the error
Run time Error '3031'
Not a valid password
Is there any way to pass the password through in the code when peforming the Dmax?

thanks

 

[lynxbci]

Hi
I solved this issue. Because the links were created before the source tables were encrypted they stooped working. To fix this all i had to do was re-create the link and all worked ok.