In my Access application I use Access as the front end and SQL Server as the backend database. In a sub-procedure
I first checks to see whether or not the user has a folder on his local C: Drive and if so, delete all .XLS files within this folder.
I placed the Access adp file on a server. Then a user accesses the apd file on the server. When the application reaches the line:
Kill "C:\SENTSPRING\*.XLS" <-------------- this line is highlighted in yellow by the compiler
A runtime error is generated Runtime Error 70
The user does not have permission to delete the XLS files in a folder C:\SENTSPRING on his local drive.
Do you know how I can avoid this error ?
If isFileExist("C:\SENTSPRING\*.XLS") Then