You've several options, but you might have to copy the entire DB instead of one table. BCP initially sounds like the best option, but replication might fit as well. - replicate the table only, at once ...

Ok in MSAccess I can send an SQL string to a server I'm connected to and as I understand it that string can contain anything. Basically it would behave as if I was connected to the server directly and ...