On 11/8/2011 2:27 PM, Dan Covill wrote: > On 11/08/11 11:13, MB Software Solutions, LLC wrote: >> A quick thought: make remote views, grab all the data in, then combine >> them into one large mess, er, uh, I mean database. If the output must >> be an Access database, you can then use a utility or SPT to write the >> clusterbang back to Access. I think Craig Boyd has such a utility? > > What he said. Manipulate it in VFP, then stuff it back in Access. > > One caution. When you get all 11 years added in, how many records will > you have? Access is known to get horrendously slow with large record > counts. > > Dan Covill
Plus, what about the primary/candidate keys? Any concerns there? -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/4eb98659.1030...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
