Robert L. Stewart
rl_stewart at highstream.net
Wed Apr 25 08:15:19 CDT 2007
You need to go to the books on line and read up on Linked Servers. It is not that difficult to do. But, once done, it is very simple to access the information. You can even link Access tables to SQL Server this way. Robert At 07:47 PM 4/24/2007, you wrote: >Date: Tue, 24 Apr 2007 17:36:05 -0400 >From: "Michael R Mattys" <mmattys at rochester.rr.com> >Subject: Re: [AccessD] using a saved SSIS with VB.Net >To: "Access Developers discussion and problem solving" > <accessd at databaseadvisors.com> >Message-ID: <00ca01c786b8$911c3d80$0302a8c0 at Laptop> >Content-Type: text/plain; format=flowed; charset="iso-8859-1"; > reply-type=original > >John, > >I've read through your description and see the bottlenecks. >All I can think of is that you could have this running distributed >across machines (but I know you thought of that). > >Robert, > >Please explain your idea a little further - how to set up. > >Michael R. Mattys >MapPoint & Access Dev