SQL Server vs Access HELP!!!

[pachjo]

Could a guru of networking and databases please help me with this problems please?

I need to know which of the following methods is better, ie less network pounding....

Situation:

A sql server database running on a host 25 miles away.

two maybe three queries need to be run to import very large data into a local c: drive database.

Option 1:

An MS Access database application with the required make table queries

Option 2:

A VB.NET application importing the data into a mdf file using sql server datasource

Is my thoughts that option 2 would be more efficient and less network hungry?

Thanks for any advice on offer....

 

[Arg81]

How are the sites connected? i.e. what type of WAN are you using?

Is the database to be shared to more than 1 user?

Have you got an SQL server at the 2nd site? depending on your WAN, I'd suggest the best way would be SQL replication on the server end.