I have a small local reservation database made in MS Access which I
update with new reservations 3-4 times every day. I also have a
webpage where it's possible to see the reservation status online.

At the moment I upload the complete DB from my computer to the
FTP-server every time I have made a change, but recently I have heard
that it's possible to only upload the update changes via a TXT file.
I.E in the same moment I update the local DB via Access the
SQL-queries of the update are written (with VBA?) to a TXT file. When
I'm finished I upload the file to an ASP page which execute the
SQL-queries to the online database file.

This sounds like a very good idea since I have a slow modem connection
and the size of the complete DB file is about 2 Mb. So now I'm curious
if someone else have tried to update an online Access DB the way I
described above? I don't know where to start since I'm new to VBA in
MS Access, so I would be very thankful for any tips, code examples
and/or webpages which describes this.

-- Mattias --