canadiankp
Programmer
I have a visual foxpro table (a .dbf file) that I've updated through access 2K vba via an odbc connection. After the update (recordset is close), I want to run a small vfp executable from access vba on the table that I've updated. example:
...
Shell myVFP.exe
However, I keep on getting a 'file access is denied' error. If I close the project in access, I'm able to run the vfp executable. I think the error is due to access keeping a reference to the dbf file. How can I fix this problem?
...
Shell myVFP.exe
However, I keep on getting a 'file access is denied' error. If I close the project in access, I'm able to run the vfp executable. I think the error is due to access keeping a reference to the dbf file. How can I fix this problem?
