changing the attributes of a file 1

[Junior1544]

i have a excel import setup for my database... every thing works fine except one thing... i want access to delete the source file once it's done with every thing else... but some times the file is marked as read only, and access gives an error and stops the code...

how can i go about deleting the file any way, or turning the read only attribute off then deleting the file??

right now i'm using kill to delete the file.

--James JHauge@jmjpc.net
Life is change. To deny change is to deny life.

 

[twinmill]

Dim MyFile As String
SetAttr MyFile, vbNormal

 

[Junior1544]

the more i looked, the harder it seemed... i was even working on using a batch file to change it... thank you...

--James JHauge@jmjpc.net
Life is change. To deny change is to deny life.