Web ODBC question

Hi there,

I am looking for some advice. I am just about to start setting up an Access database. Most of it will be local, but some of the information needs to be updateable via the internet. I supposed that I will have to have one database held locally and another held on the web server so it can be updated. I was thinking the local one could be in Access and the web server database would be in SQL Server to make the tables accessible via ODBC. That way local users could update the tables on the web server as well as users over the internet.

For administrators to edit the database would it be best to have an ODBC link to the tables on the web server so they could update the information directly, as well as updating locally held information, or would it be better to try and just copy the data down to a local copy using something like XML streams? I know there are security implications and server resources to consider about the ODBC link over the web and I don't know much about this set up.

If anyone has any advice to offer I would be very grateful.

Many thanks