>I have a 6.0 app and I want to add a module that will handle packing tables and such stuff. I created a table containing information on the local tables with the intent to scan through and pack. No matter what I try, setting exclusive to .T. on each table, setting the form's data environment to open and close tables automatically, I always get the error that the selected table must be opened exclusively. These tables exist in a database which are part of the environment for the previous form also where I do not use them exclusively for shared reasons. What am I missing?
>
>Also, are there specific tasks I should be handling related to maintenance of the databases? If so, does anyone know where I can find out more or get code examples?
>
>Regards, Renoir

Once you've opened a table, you can't change the exclusive status of it without closing the table and re-opening it. It looks like you're using the default data sessions in both forms... if you were using private data sessions, the second form would give you an error that the table is in use. When a table is opened exclusively, it can't be opened anwhere else - on another machine or in another data session.

One suggestion I would make is that you reuse deleted records instead of packing the table.