Results 1 to 4 of 4

Thread: Within Access 2000, connect to a DSN

  1. Dec 8th, 2003, 07:57 PM #1
    JohnSmith
    JohnSmith is offline

    Thread Starter
    Fanatic Member
    Join Date
    Feb 2002
    Location
    Hampton Beach
    Posts
    513

    Question Within Access 2000, connect to a DSN

    From within an Access 2000 database, can you access an external DSN? If so how can I do this? I want to take data from another backend...
    Reply With Quote Reply With Quote
  2. Dec 9th, 2003, 10:55 AM #2
    M Owen
    M Owen is offline
    Lively Member
    Join Date
    Jun 2003
    Posts
    114
    Sure ... Ex:

    Set MyConnect = New ADODB.Connection
    Set MyRecSet = New ADODB.Recordset

    MyConnect.CursorLocation = adUseClient
    MyConnect.Open "DSN=Billing System;"
    Reply With Quote Reply With Quote
  3. Dec 9th, 2003, 08:42 PM #3
    JohnSmith
    JohnSmith is offline

    Thread Starter
    Fanatic Member
    Join Date
    Feb 2002
    Location
    Hampton Beach
    Posts
    513
    Do I paste all of the recordset and connectionstring into a module?
    Reply With Quote Reply With Quote
  4. Dec 10th, 2003, 08:12 AM #4
    M Owen
    M Owen is offline
    Lively Member
    Join Date
    Jun 2003
    Posts
    114
    That is up to you ... I cannot tell you how you should design your program.
    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