Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2005
    Posts
    9

    Unanswered: VBA Connection Strings and MS Access

    Hello,

    I'm a pretty advanced user of MS Access and have some VBA background, but have never had to set up a connection to a another database.

    I'm basically just trying to learn how this is done by connecting two separate Access databases. Can anyone tell me how to do this with VBA?

    I know how to link and import tables, but want to learn the VBA string for connecting to remote databases.

    Thanks,
    Tim

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,472
    Provided Answers: 10
    Long time age can't find that mdb file

    Dim db as database
    Dim rst As Recordset
    set db = currentDB '= to the current database
    so
    set db = OpenDatabase(path/filename) '=should open other database

    Set rs = db.OpenRecordset(.....
    Last edited by myle; 10-05-05 at 14:20.
    hope this help

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

  3. #3
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Back to Access ... ADO is not the way to go for speed ...

  4. #4
    Join Date
    Sep 2005
    Posts
    9

    Talking Thanks

    Thanks guys.

    Both posts were very helpful.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •