How to close all access to the Access Database in VB6?..

October 17, 2010 9:02pm CST
I recently made an application in which I made this feature "BackUp Data" wherein I used the filecopy mechanism "FileCopySource,Destination"..The only problem is that this code will have an error if the database in in use..And it's used by the most of the forms if loaded..I put a code wherein in all Form_Unload events.."db.Close" so that any set access to the database is closed..But still, there's something still acessing the database.. Do you know any code which will close any active process that is accessing the Access database?..Or any method that will pinpoint which code or form is accessing the dababase?..Any help would be greatly appreciated..Thanks..