i have a recordset in which i close the connection and then i open an access application. i have tried everything from using a seperate connectionvariable and closing the connection and the database to using just a recordset and closing it to halting the program so that the .ldb file disappears. has anyone had this problem before? any suggestions? (even though i probably tried them all)

thanbks, PJ