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 SkipVought 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
0
0
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
  • Question
Populate access table from excel
Replies
6
Views
226
OCM
OCM
Moss100
  • Locked
  • Question
Upgrading from Access 2013 - whats the best option
Replies
2
Views
137
Moss100
Moss100
lmcate
  • Locked
  • Question
How to Open ACCESS (MDB) from an HTML Page 1
Replies
2
Views
167
lmcate
lmcate
cimoli
  • Locked
  • Question
Best password method with time factor
Replies
3
Views
96
cimoli
cimoli
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
177
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top