Thanks for the suggestion. The kill statement did not work with .mdb files so i need to find another way around my problem(in tables forum as 'file description').
Thanks
Yes your right, my problem was that the variable representing the name of the database had changed when I ran the kill line. I have sorted it now by making it constant. Thanks
Chris