I am trying to link to a .dbf file (I think its probably a DB 5 file but not sure). THe file is being used by a caller ID program, and so that program has the file open. I am trying to link to the same table using access but it keeps telling me that the file is in use.
I can link to this file using Access 97, but using access XP, or even access 2000, it doesnt let me.
With whatever app you use to access it, you must access it shared. If the caller id app has the table opened exclusively, unless you can figure out how to get that app to use the table shared, you will be out of luck. Since you said you were able to access the table in one version of Access but not others, I'm guessing the table is currently open shared.
Anyway, here are some example connection strings that may help:
There should be an option on the attach-step for "open exclusive." However, ".DBF" file formats vary widely despite the identical-looking name, and so do the various drivers used to access them. If the wrong driver is used, perhaps it has locked-out incompatible drivers by locking the file exclusively?