Linked Table

[Keith]

I want to create several linked tables (or imported data) in a database
which are linked to several password protected (and shared, though the
sharing could be removed if I can get this to work)) Excel spreadsheets. I
have linked to the ones which are not protected ok, but I can't find a way
of doing this when they are password protected, even though I created the
spreadsheets and protected them and obviously know all the passwords.

Any help or ideas would be greatly received.

Thanks

 

[Guest]

Can you give us a little more to go on? What "type" (for lack of a better
word) of protection do you have on it? Is it just password protected? Is
the sheet protected or the entire workbook? What "error" are you getting?

 

[Keith]

They are just password protected spreadsheets, none of the sheets are
protected, just purely a password to open the book.

 

[Guest]

Well hate to say it but I never ran into this. Did you try posting this in
the Excel forum? You could try code. Open the spreadsheet thru code and
read the data into a table in Access. Just a thought.

 

[Keith]

If the Excel spreadsheet requires a password to modify, but you can still
read without the passsword, then Access can link to the data, but if it
requires a password to open it at all, then Access will not fetch the data.
I know that if you try to link to an Access database that is password
protected, it will ask for the password when you first set up the link, and
then it saves the password with the linking information, but with an Excel
workbook I do not get the request for a password, just the error message.

Thanks for the reply and if anyone else has come across this and overcome
the problem I would be grateful for the workaround.

Thanks