Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2013

    Unanswered: Is a File DNS possible with the access driver for ODBC?

    After hundreds of attempts and dozens of work around, I feel a bit defeated.

    My goal is to create a DSN which I will be able to access from another computer on the network. I have had trouble with user DNS and system DNS and it looks like the reason is that they are both stored in the registry. While I could access the data source on a superficial level (see the table name and column name,) I was unable to get any more functionality out of it. File DNS seemed like the best bet from, but that option seems to be disabled with the access driver.

    My question is whether it is even possible to communicate with access using ODBC over a network, or whether it simply can't be done?

  2. #2
    Join Date
    Jan 2009
    Kerala, India
    If Server and Client machines are on the same network and if you have access rights on both it is better to map the target location as a local drive and link the tables to your database.

    Without mapping the Server Folder to your client side machine you can directly reference the target with full server location address: \\ServerName\Foldername\Database to link the tables to your database. This is a better method than mapping to a drive letter.

    Client Machines on the same Network also can be linked together (Pier-to-Pier) by the same method explained above, provided if you know the target machine's network name and you have access rights.

    DSN is created and stored on the local machine to access external data sources. To create DSN, external data source's driver must be installed on the local machine. As far as I know the DSN created on one machine cannot be used from another machine on the network.

    Refer this link for some details:

    Linking with IBM AS400 Tables/

    The IBM AS400 Client side ODBC Driver must be available (this will be installed when AS400 client side software is installed) on the local machine to create a DSN and access rights to iSeries Tables also required. The above link deals with a System DSN Creation.
    Last edited by apr pillai; 08-11-13 at 15:58. (Learn MS-Access Tips & Tricks)
    Learn Advanced MS-Access Programming with sample VBA Code.

    All responses are based on Access 2003/2007

  3. #3
    Join Date
    Feb 2004
    New Zealand
    Provided Answers: 10
    Also u must have AS400 LOGIN that has access to the said table/files
    hope this help

    See clear as mud

    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 based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008

Tags for this 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