I run a routine that interacts via DAO w/ Access database. When it's done, I want to open the database for the user to see. The only way I know how to do this is with ADO (e.g., Access.Application.OpenCurrentDatabase and .UserControl = True).
Problem is... I get an error saying that the database is open by another user -- even though I've closed db object and set to nothing. I understand that closing db object via DAO's close method affects the variable and not the db itself, but how do i effectively close the db so that I can open it again in ADO? Or can I accomplish the same thing another way? Thanks. -Brad
Problem is... I get an error saying that the database is open by another user -- even though I've closed db object and set to nothing. I understand that closing db object via DAO's close method affects the variable and not the db itself, but how do i effectively close the db so that I can open it again in ADO? Or can I accomplish the same thing another way? Thanks. -Brad