Given:
form with one view in the dataenvironment. (abbrev_by_type)
this view was built using only one base table. (abbrev)
the view is local.
NoDataOnLoad .T.
The cursor property exclusive is .T.

In the AfterTablesClose event for the Dataenvironment:
wait window "Dataenvironment.AfterCloseTables" timeout 1

lnTablesUsed = AUSED(gaInuse)
wait window "Tables used: " + str(lnTablesUsed) timeout 1
FOR m.i = 1 TO lnTablesUsed
wait window gaInuse(m.i,1) timeout 1
ENDFOR

I've got two problems:

1. Even though it looks like everything is set to open the table(s) exclusively I can not PACK after deleting records.
"Table must be opened exclusively"

2. The above code in AfterCloseTables is showing that the base table abbrev is not getting closed. The view is, but not the table it's based on.

Assistance please,

Thanks, Kim