Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Open password protected Excel linked files, from Access

Status
Not open for further replies.
gungfukid

gungfukid

Programmer
Apr 9, 2001
9
GB
I have a passsword protected Excel file (password used to protect hidden sheets) which has some of its sheets linked to an Access database. Access however cannot decrypt the file now it has a password.

How do I get Access to specify the password(Excel) when opening the linked tables?

Thanks in advance!
 
Status
Not open for further replies.

Similar threads

OCM
  • Locked
  • Question
Populate access table from excel
Replies
6
Views
5K
OCM
OCM
lmcate
  • Locked
  • Question
How to Open ACCESS (MDB) from an HTML Page 1
Replies
2
Views
5K
lmcate
lmcate
ameedoo3000
  • Locked
  • Question
switch between two open database
Replies
12
Views
2K
Andrzejek
Andrzejek
renigar
  • Locked
  • Question
Access VBA Syntax Error 1
Replies
5
Views
5K
Andrzejek
Andrzejek
grnzbra
  • Locked
  • Question
Using Access Database Without Having MS Access
Replies
9
Views
6K
grnzbra
grnzbra

Part and Inventory Search

Sponsor

Back
Top