Arthur Fuller
fuller.artful at gmail.com
Thu Jan 22 15:27:43 CST 2015
Mark, You say that as if it were a bad thing. I'm not sure why, particularly when from within Access, you can use Pass-Thru Queries to fire the stored procs. Arthur On Thu, Jan 22, 2015 at 3:37 PM, Mark Simms <marksimms at verizon.net> wrote: > My experience a few years ago: if you used linked tables to SQL Server, > query retrieval times were 2x that of native SQL queries. Updates and > Inserts were up to 10x !!! > > Conclusion: you must use stored procs for everything....reports, forms, > etc. > > > You know what I find most interesting in this whole transition is that > > SQL > > Server Express didn't seem to catch on. > > > > Susan H. > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Arthur