Results 1 to 4 of 4

Thread: Linked SQL table

  1. Oct 22nd, 2002, 11:54 AM #1
    Split
    Split is offline

    Thread Starter
    Lively Member
    Join Date
    Oct 2002
    Location
    Los Angeles, CA
    Posts
    73

    Linked SQL table

    Is it possible to link SQL server table in the same manner like Access linked tables? Can I link SQL server table to exsiting Access db (or any other DB)? If I cannot, what can I do instead of it?
    Reply With Quote Reply With Quote
  2. Oct 23rd, 2002, 02:35 AM #2
    Ecniv
    Ecniv is offline
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343
    In theory yes you can if you use access as a go-between. It holds all the tables and you link through it to the Sql server.

    The sql tables then act like tables in the access mdb.


    Vince

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...
    Reply With Quote Reply With Quote
  3. Oct 23rd, 2002, 05:33 AM #3
    swatty
    swatty is offline
    Frenzied Member swatty's Avatar
    Join Date
    Aug 2002
    Location
    somewhere on earth
    Posts
    1,478
    Yes you can but in the box files of type you have to select ODBC Databases()

    If no dsn is known you can create one from there.

    For SQL-server you need to do it through a dsn
    Code:
    If Question = Incomplete Then
   AnswerNextOne
Else
   ReplyIfKnown
End If
    cu Swatty
    Reply With Quote Reply With Quote
  4. Oct 23rd, 2002, 10:58 AM #4
    Split
    Split is offline

    Thread Starter
    Lively Member
    Join Date
    Oct 2002
    Location
    Los Angeles, CA
    Posts
    73
    Thanks guys
    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