In my VB6.0 project, I am having a problem with a Run-time error '3356' (Database already opened by another user). Here is some background information. 1st thing the program does is open a DataReport for some printing purposes. 2nd thing is I have a command to compact the database after all other database events in the program are complete. For some reason after the DataReport is ran, I guess the DataEnvironment connection remains open even after I am using the DataEnvironment.connection.Close command. This causes the error to occur before the compacting action can be performed. Does anyone know a way to terminate this connection to avoid this Run-time error? I appreciate your help!
John
