Hi,
I have a wee problem. I am accessing an access 2000 database using VB6 thru the DAO object. One of my users is having problems in that the access database is not being closed on his machine when it should be. What happens is, I open the database, open the recordsets, transfer in the requires data, close the recordsets and close the database - then I rename the database. This is all done in the code but on my users machine it crashes out on the renaming of the database - the reason for this is that the database has not closed down properly (ie the .ldb file still exists in the directory) On my own machine with the same executable - this does not happen. Then when I close down the exe on the users machine - the database then closes fully (ie the .ldb file disappears) but there is no further close commands in the exe to do this. I hope this is clear - its a real odd-ball problem and I'm not sure where to go next to solve it. Is there a way to kill the db variable which is set to the database or am I on the wrong track altogether
Thanks in advance fo any help
John B
I have a wee problem. I am accessing an access 2000 database using VB6 thru the DAO object. One of my users is having problems in that the access database is not being closed on his machine when it should be. What happens is, I open the database, open the recordsets, transfer in the requires data, close the recordsets and close the database - then I rename the database. This is all done in the code but on my users machine it crashes out on the renaming of the database - the reason for this is that the database has not closed down properly (ie the .ldb file still exists in the directory) On my own machine with the same executable - this does not happen. Then when I close down the exe on the users machine - the database then closes fully (ie the .ldb file disappears) but there is no further close commands in the exe to do this. I hope this is clear - its a real odd-ball problem and I'm not sure where to go next to solve it. Is there a way to kill the db variable which is set to the database or am I on the wrong track altogether
Thanks in advance fo any help
John B