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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

IMPORTING A TABLE FROM PASSWORD PROTECTED DB

Status
Not open for further replies.
PrgrmsAll

PrgrmsAll

Programmer
Apr 8, 2003
180
US
I have a blank database into which I would like to import a table from another database. The other database is password protected, which is fine, I have the password. My issue is that I wish to place this import action into a macro ...

Is there the provision in the macro design to enable the hardcoding of a database's password?

If not, is there a provision in VBA to perform this?

Any advise/suggestions would be appreciated.

Thanks in advance.
 
Status
Not open for further replies.

Similar threads

OCM
  • Locked
  • Question
Populate access table from excel
Replies
6
Views
3K
OCM
OCM
A
  • Locked
  • Question
Print Table attachment
Replies
2
Views
182
andre.meyer
A
ameedoo3000
  • Question
Clear all table contents without deleting records
Replies
15
Views
607
ameedoo3000
ameedoo3000
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
721
renigar
renigar
Bubba002
  • Locked
  • Question
WHERE clause in the Set command of an db.OpenRecordset method
Replies
16
Views
809
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top