>I am running a program and and it has a begin transaction. When the program hits this, I get the error "one or more structural indexes are open. Please close them and retry the begin transaction. Why do I get this message and why would it care that an index is open.

I've received that message after using the "searcher" form. That form uses a parameterized view as the grid's .RecordSource but typically each column is indexed for searching. The transactions occur well after someone has "found" a record, modified it, and is trying to update the database. The workaround was to issue the CLOSE INDEXES command in the .Destroy event of the searcher form and things go OK. I believe that if you look back far enough, you might even find a thread where I brought up this issue long ago.

Steve