VB Code to BackUp Data from SQL to Access

[manojkapparath]

Sir, I wish to know the Code in VB to Copy the data of all tables in the database of an SQL server to the database in ACCESS.The purpose is to keep a backup of data in another server .

[willakawill]

This question might be answered better in the Access or SQL Server forums. I have copied your post to both.