Not a Valid Password Error

[AshikHusein]

I am trying to link some tables to my front end and the tables are within an encrypted and password protected database.

When I link the tables, it asks me for the passwork which I enter and the tables do get linked to the fron end..

However when I try to attach the table to a combo box or try to open the tables I get a message which says "Not a Valid Password"

So it does allow me to link the tables with the required password but when I try to open the linked tables it gives me the above error.

I am using Access 2010..

Would appreciate an insight into this. The above process worked well with older versions of access. Thx.

 

[Ari]

Hi

Use the compact and repair when restate the links. Access 2010 has a bug that wont fix using the compact and repair.

 

[AshikHusein]

Compact and repair did not work..Is there any way I could do it through VBA?