I have a program that is using an ADO data control connected with a
connection string. I also have a data environment attached with a
connection string. I want to give the option at exit to compact the data
base. The problem is that if I don't run a data report the program
compacts the data base just fine. But, if a data report has been run the
compact routine generates an error that I am trying to open a .......
already exclusively opened by me on my machine. I have tried everything
to terminate the data environment connection. I have even created a
seperate form to handle the compaction and when this form opens I am
unloading the form that has all the database connections, this doesn't
do it either. Any suggestions would be greatly appreciated.

One more note, if I make the connections using an ODBC datasource
everything works fine..... Go figure.