[dba-SQLServer] linking back...

Gustav Brock Gustav at cactus.dk
Mon Sep 12 03:52:02 CDT 2011


Hi Mark

It certainly can, both for read and write. It is explained in the BOL and in daily use at one of our clients linking two Access 2.0 database and one Access 97 database in use by third party apps.

The only thing I miss is how to open those links non-exclusively; right now the users have to step out of the apps using the Access databases (no big deal, three users only) before transfer can take place between SQL Server 2005 and the linked databases. The transfer is controlled from my C# WinForms app which uses DataTableAdapters to connect to the databases, then custom code performs one-way or two-way appending or updating of records (I don't delete anything) 

Another option I have yet to test is the Sync Framework of Visual Studio. This should take care of the table plumbing to enable you to code on a higher level.

/gustav


>>> marklbreen at gmail.com 12-09-2011 10:03 >>>
Hello Francisco,

Do you mean that SQL Server can link to a Jet db?  If so, I did not know that.

Or are you attempting something else?  I presume that you do not want to install Office ?

Mark


On 6 September 2011 22:27, Francisco Tapia <fhtapia at gmail.com> wrote:

> I thought I had a grasp of this but there is something wrong with my machine
> and the new sql server 2008 r2 cluster :-|.  I have a vendor specific Access
> Database which I must link down to vs Upsizing, the vendor doesn't support
> the upsize, but being that I'm on a new OS and the culster is on 2008, I
> don't see the drivers for the jet engine... :-| anyone been through this hoop?
>
> arg!
>
>
> -Francisco
> http://bit.ly/sqlthis   | Tsql and More...





More information about the dba-SQLServer mailing list