SQL Insert versus Table.Append

I am using a single dbf table which has 100,000 records.

currently using the standard TTable component:

Table.Append
(20 fields).................
Table.Post

to add records but I am starting to lose records (it is writing across
a network).

Simple question.

1.Will using an SQL Component and INSERT INTO statement improve the
performance and ,especially, stop losing records?
(I have set up a Database ALIS using the STANDARD driver in the BDE
Config.)
2. Will this method allow me to run multiple (write only) users on the
same table.

OR   Do I need a separate SQL Server (MySQL or Firebird or ????)

Advice is appreciated.