Mark Breen
marklbreen at gmail.com
Thu Sep 15 04:28:14 CDT 2011
Hi Gustav, so when you link them, does that mean tha in SSMS, you can write queries against the Jet tables ? If so, why can't you schedule a job to do the update up and down, regardless of exclusive use. Also, just a question, I used to use DTS a lot back in SQL 2000 days, I have not used it too much since 2005 / 2008 / 2008 R2, but did you attempt to get SSIS to manage the data management, it sounds like it it the type of thing it should be used for. thanks Mark On 12 September 2011 09:52, Gustav Brock <Gustav at cactus.dk> wrote: > 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... > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >