<div>
if this is to be a regular &quot;scheduled&quot; event you could even consider snapshot replication. &nbsp;
</div>


if this is to be a regular "scheduled" event you could even consider snapshot replication.  

<div>
MOderator,<br />
Pls close this question
</div>


<div>
ajaykothidar, you don't just post in the thread and ask that it be closed. &nbsp;You need to post a &quot;question&quot; in CS with a link to this question and give the reason for closing it....What is the reason??
</div>


ajaykothidar, you don't just post in the thread and ask that it be closed.  You need to post a "question" in CS with a link to this question and give the reason for closing it....What is the reason??

<div>
<div class="content wysiwyg-content">
Hi <br />
I am trying to take the backup of the data of our application which has database on <br />
SQL Server 2000.I need to take the backup on MS-Access database.<br />
All this has to be a run time process.<br />
<br />
I have a list of specific static data tables which need to be first created in MS-Access<br />
and then the data needs to be copied.<br />
<br />
Currently i am using DAO to create Access database,tables and fields one by one which is very tedious.<br />
<br />
Is there any method/function using VB6 to copy the schema of tables in SQL 2000 to MS-Access.<br />
<br />
Regards<br />
Ajay
</div>
</div>


Hi 
I am trying to take the backup of the data of our application which has database on 
SQL Server 2000.I need to take the backup on MS-Access database.
All this has to be a run time process.

I have a list of specific static data tables which need to be first created in MS-Access
and then the data needs to be copied.

Currently i am using DAO to create Access database,tables and fields one by one which is very tedious.

Is there any method/function using VB6 to copy the schema of tables in SQL 2000 to MS-Access.

Regards
Ajay

Copy Table/data from Sql server to Ms-Access using VB6.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.