Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Sep 2002
    Location
    London, England
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linking to dbase files (2000)

    I have to create an Access application that will regularly extract data from an existing dbase application. Whilst experimenting at the client's site, using Access 2000, I managed to create links to some of the dbase files within Access, but some of the files refused. In each case a dialog box poped up to say that the file could not be linked because either the permissions were wrong, or the file was in use. As I can link to some of the files, I am working on the assumption that the problem was caused by the files being in use. I'm not on very solid ground here, but I assume that Access is using its ISAM drivers to link the dbase files. Are there any settings that I can change for these drivers, or are alternative drivers available? And, just in case this is a permissions issue, is there a way of including the logon and password when creating a link to a dbase file?

    The dbase system is dbase IV, version 2.0. I expect to create the application in Access 2003.

    Thanks in advance for any advice,

    Ian

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking to dbase files (2000)

    The main issue when creating the link is that nobody can be in the file when you link to it. We have found that we can get around this issue using network drive mapping. Make a copy of the file you want to link to and copy to another location on the network. Map the drive to the new mapped location and link to the file. When you map back to the original network location the link will still be in effect. For example, I have a table that maps to drive Natafile on server 1. If I copy the database containing that table to server 2 and map the drive to Natafile. I can link to the table on server2 which nobody is using. When I map back to server 1, the table is linked to the location where the file is being used.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

Posting Permissions

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