exclusive data locks

[racquetballguy]

I have a very old program that creates ".dat" files. (I have modified the registry to allow Access to link/import these files)

As long as no one is using these files in the other program I can link/import these into Access with no problem. However if someone is using the .dat file the file is exclusively locked and access won't let me link/import it.

I know you can programatically change the file extention to "txt" and then link/import but I am not sure this is a good idea if the .dat file is open.

Does anyone know a good workaround for this problem?

Thank You
Ivan

[Rabbit]

You can programatically make a copy of the file and import/link that instead.