Results 1 to 3 of 3

Thread: Odbc

  1. #1
    Join Date
    May 2003
    Posts
    70

    Unanswered: Odbc

    Hi,

    I have a MSDE database on 1 computer. I have an Access MDB file on the same computer which has table links to the MSDE database. Therefore, I have a SQL Server DSN on that computer.

    Now, if I want to access that MDB file from a different computer on the network, it tells me that I need a DSN there as well.

    Is there any way that I can do this without having to create a DSN on each workstation that will be accessing the MDB file?

    Thanks,

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    No. Not that I'm aware of ... I don't think you can access a DSN setup on others PCs on a network.

  3. #3
    Join Date
    Sep 2003
    Location
    T.O.
    Posts
    326
    You may be able to access the non-DSN linked tables through an ADO connection. This link may be of use:

    http://www.able-consulting.com/ado_conn.htm
    All code ADO/ADOX unless otherwise specified.
    Mike.

Posting Permissions

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