ACCESS FEED: Re: [MS_AccessPros] Ms access using SQL server

Minggu, 17 Mei 2015

Re: [MS_AccessPros] Ms access using SQL server

Terence-

Client/Server 101:

There is a TON of overhead creating the connection to the back end, especially when it's SQL Server. It still wouldn't be great, but I bet your report would run much faster if you first open the table in Datasheet view (which establishes a Connection), then while leaving the Datasheet open, run your report.

Classic "trick" in any C/S application is to open some recordset to the back end on startup and leave it open for the duration. You'll suffer the overhead only once because all subsequent hits to the server will share the already opened connection.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On May 18, 2015, at 7:25 AM, 'Graham Mandeno' graham@mandeno.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Hi Terence

That's a very old version. I suggest you download and try either the ODBC Driver 11

(https://msdn.microsoft.com/en-us/library/jj730314%28v=sql.110%29.aspx )