<div>
I'm assuming that using linked table is not an option.<br />
<br />
One practice I have used is to link all the tables you need, then create a local copy &amp;&nbsp;create all the relations ships then have a process to delete the data from each local table in turn and then repopulate (delete and insert queries from the linked tables).<br />
<br />
You must get the delete order and insert order correct so that relationships do not hinder the process.<br />
<br />
<br />
Kelvin
</div>


I'm assuming that using linked table is not an option.

One practice I have used is to link all the tables you need, then create a local copy & create all the relations ships then have a process to delete the data from each local table in turn and then repopulate (delete and insert queries from the linked tables).

You must get the delete order and insert order correct so that relationships do not hinder the process.


Kelvin

<div>
<div class="content wysiwyg-content">
I have a database in MS SQL Server 2005 that from time to time needs to have some tables brought into Microsoft Access.<br />
<br />
I have no problem doing this using a DSN and importing but every time I do it I have to make a new Access database and set up my table relationships all over again which is time consuming.<br />
<br />
Is there a way I can ideally ust update my current access database with the new records from my SQL Server 2005 database, or if not somehow save my relationships so I can apply them to the new Access Database?<br />
<br />
Any help, thoughts, suggestions is appreciated.
</div>
</div>


I have a database in MS SQL Server 2005 that from time to time needs to have some tables brought into Microsoft Access.

I have no problem doing this using a DSN and importing but every time I do it I have to make a new Access database and set up my table relationships all over again which is time consuming.

Is there a way I can ideally ust update my current access database with the new records from my SQL Server 2005 database, or if not somehow save my relationships so I can apply them to the new Access Database?

Any help, thoughts, suggestions is appreciated.

MS SQL 2005 to Access 2003 via ODBC

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.