Results 1 to 4 of 4

Thread: Link

  1. May 1st, 2003, 01:04 PM #1
    Liquid Metal
    Liquid Metal is offline

    Thread Starter
    Frenzied Member
    Join Date
    Apr 2003
    Location
    The Future - Skynet
    Posts
    1,157

    Link

    Is there a way to create SQL link in Access using VBA?
    Last edited by Liquid Metal; May 1st, 2003 at 01:08 PM.
    I'll Be Back!

    T-1000

    Microsoft .Net 2005
    Microsoft Visual Basic 6
    Prefer using API
    Reply With Quote Reply With Quote
  2. May 1st, 2003, 01:08 PM #2
    techyspecy
    techyspecy is offline
    Let me in .. techyspecy's Avatar
    Join Date
    Aug 2002
    Location
    Back to VBF.
    Posts
    2,456

    Re: Link

    Originally posted by Liquid Metal
    Is there a way to create SQL link in Access?
    Yes just right click in access db and select data links ... then use a sql provider and specify the destination.
    Reply With Quote Reply With Quote
  3. May 1st, 2003, 01:15 PM #3
    Liquid Metal
    Liquid Metal is offline

    Thread Starter
    Frenzied Member
    Join Date
    Apr 2003
    Location
    The Future - Skynet
    Posts
    1,157
    I know how to do that. I was referring to do it with VBA.
    I'll Be Back!

    T-1000

    Microsoft .Net 2005
    Microsoft Visual Basic 6
    Prefer using API
    Reply With Quote Reply With Quote
  4. May 1st, 2003, 02:08 PM #4
    Liquid Metal
    Liquid Metal is offline

    Thread Starter
    Frenzied Member
    Join Date
    Apr 2003
    Location
    The Future - Skynet
    Posts
    1,157

    Thanks anyway Techyspecy

    Here is the solution.
    Code:
        DoCmd.RunSQL ("DROP TABLE TestTable1")
    DoCmd.SetWarnings False
    DoCmd.TransferDatabase acLink, "ODBC Database", "ODBC;DSN=LocalServer;DATABASE=Test", acTable, "Table1", "TestTable1"
    DoCmd.SetWarnings True
    I'll Be Back!

    T-1000

    Microsoft .Net 2005
    Microsoft Visual Basic 6
    Prefer using API
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width