Replicate Access to SQL Server 2005 1

[becks774]

Hello All,

Is it possible to replicate an Access mdb to SQL Server 2005?

Thanks!
Becca

 

[mrdenny]

No, Access can not be the publisher. You would have to move the tables to SQL, and link to them from Access. Then either query the tables directly within the SQL Server, or replicate the needed data to another SQL Server for what ever reason it's needed.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[becks774]

That is what afraid of .... Thank you!

 

[mrdenny]

No problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog