Linking an Excel Worksheet to Access with Passwords on the Worksheet

[riggo44]

I have an access db that has several linked in excel worksheets. To run queries in access off these worksheets the passwords must be logged into the excel worksheets, so bascally the sheet has to be opened. Is there some VB code where access can lookup the passwords to the worksheets?

Thanks

 

[Darrylles]

Hi rigg,

If I understand you correctly, the passwords are on a seperate worksheet?

If so, then create another link - to the password worksheet, and then treat it like a normal table.

E.G. Tables->New Link and point it to the spreadsheet worksheet.

ATB

Darrylle

Never argue with an idiot, he'll bring you down to his level - then beat you with experience.

 

[riggo44]

I really meant to say that I have several separate workbooks each of which has different passwords that are linked to an access db.

When going into access and trying to open one of linked workbooks I am not able to open the file. It gives me the following dialog box...."Could not decrypt file".

Does this make more sense to you?

I appreciate your responce.

 

[PHV]

Relink the tables to the worksheets with the remember password checkbox ticked.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[riggo44]

I am not aware of where you have the option to check the save password option?

Could you point me in the direction.