Do you have in the onClose of your main form:

If dmData.MyTable.State in [dsInsert, dsEdit] then dmData.MyTable.Post;
dmData.MyDatabase.Commit;

HTH,

Do a search on Google or any big Delphi site and you should find articles on
the best settings for BDE and Paradox tables. Paradox tables can suffer from
data loss and index corruption if you don't get the settings right.

Hope this helps,
Dave.

A)Setting Local Share := True:
  1)Open the BDE Administrator (found in Control Panel).
  2)Click on the Configuration Tab.
  3)Click on the + sign next to System.
  4)Click on INIT.
  5)ON the right side is a list of parameters click in the Local
Share, choose
True.

This forces the Data to be written to the database (physically), no
missing stuff on close.  This is what I think you whole problem is.

B)The use of TDatabase:
Double-click on the TDatabase component.
Fill in the fields like this:
the quoted text is what I used and you can use what you like instead
with no quotes.

Name "VHSData2"  Alias Name (leave blank, the whole point of this
exercise)
Driver name STANDARD

Parameter overrides:
"PATH=C:\Program Files\JohnK\VHS Library\Tables"
DEFAULT DRIVER=PARADOX
ENABLE BCD=FALSE

Options  check or unchecked as you see fit.

Click okay.  You will have to create a directory on your drive to
match your path and store/create your Tables in it.

In the Object Inspector changing "Connected" to True should cause no
errors.  If it does, I have no idea how you can Post anything to the
Tables.

Your TTable components should have the name ("VHSData2") in their
DatabaseName property.

Commit/Rollback/StartTransaction is used when you also have
"CachedUpdates" set to TRUE on your TTable components.

HTH,