Very Computer

Thanks in advance for any reply...
For a legacy application I need to link a dbase IV file in MS Access;
I use ADO in VBA to not to need a manual link and no need for an DSN entry
in the ODBC manager;
All is working fine if I rename the file.cdb to file.dbf, however if the
legacy application is running, I'm not able to rename the file since it's
locked.
Note that I only need read access to the table except when the legacy app
isn't running, then I need write access.
So in all, I want to open a file.cdb as an file.dbf without renaming,
there's also an index file with the extension file.mdx, I asume that
extension is fine and is automatically incorporated ?

Thanks,
Jeroen.