Stuart McLachlan
stuart at lexacorp.com.pg
Thu Jan 22 18:07:32 CST 2015
Bound forms on a pass-through to a SP? -- Stuart On 22 Jan 2015 at 16:27, Arthur Fuller wrote: > 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 > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >