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

ADO Connect To Another MDB File

Status
Not open for further replies.
gharabed

gharabed

Programmer
Sep 7, 2001
251
US
I know this is probably a pretty simple question but is there a way to establish an ADO connection to another Acccess (MDB) file? I don't want to use ODBC as I know the path to the file. If you could provide an example, it would be appreciated.
 
Sort by date Sort by votes
Never mind...I figured it out...

dbConn.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & thePath

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
923
renigar
renigar
lmcate
  • Locked
  • Question
How to Open ACCESS (MDB) from an HTML Page 1
Replies
2
Views
4K
lmcate
lmcate
TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
4K
TheresAlwaysAWay
TheresAlwaysAWay
YoBi4Ever
  • Locked
  • Question
I would like to compute how many minutes or hours the employee left work by comparing two records
Replies
3
Views
352
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them? 4
2
Replies
22
Views
6K
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top