Re: [belajar-access] Share ttg cara kerja JET dgn Linked Tables

Sama-sama Mas Sofyan,...tapi mungkin saya ingin menambahkan untuk rekan2 yang lain, karena di link itu tidak dijelaskan/warning
bahwa ada beberapa konstruksi syntax SQL yang akan menyebabkan proses di client (ambil semua data di server baru di filter di client),
ini saya post ulang karena dulu pernah, semoga berguna buat yg baru membaca :

http://msdn.microsoft.com/en-us/library/dd942824%28v=office.12%29.aspx

Ringkasan :

Don't Force Local Query Processing

Don't use query constructs that cause processing to be done by Access on the local computer. The following query operations force the Jet database engine to perform local data processing:

• Join operations between tables that are linked to different data source (that is, a join between a SQL table and a linked Access table).
  
  
• Join operations based on query that uses the DISTINCT keyword, or a query that contains a GROUP BY clause.
  
  
• Outer joins that contain syntax that is not directly supported by the remote database server.
  
  
• The LIKE operator used with Text or Memo fields
  
  
• Multi-level grouping and totaling operations
  
  
• GROUP BY clauses that are based on a query with the DISTINCT keyword, or the GROUP BY clause.
  
  
• Crosstab queries that have more than one aggregate, or that have field, row, or column headings that contain aggregates, or that have an ORDER BY clause
  
  
• User-defined functions, or functions that are not supported by the remote server
  
  
• Complex combinations of INNER JOIN, LEFT JOIN, or RIGHT JOIN operations in nested queries.

---

From: Sofyan Efendi <sofyanefendi@gmail.com>
To: belajar-access@yahoogroups.com
Sent: Monday, August 13, 2012 8:32 AM
Subject: Re: [belajar-access] Share ttg cara kerja JET dgn Linked Tables

 

Luar biasa penjelasannya, lengkap dengan urutan tracenya. Terima kasih Ma Hendra atas linknya.

Wassalaamu'alaikum Warahmatullahi Wabarakatuh,
Sofyan Efendi
http://imopi.wordpress.com | http://trendmuslim.com

----- Original Message -----

From: Hendra Agestha Hamid

To: belajar-access@yahoogroups.com

Sent: Saturday, August 11, 2012 6:04 AM

Subject: [belajar-access] Share ttg cara kerja JET dgn Linked Tables

Sekedar share bagi pengguna Access ttg cara kerja JET dgn metode Link Tables,...melegakan.... :)
Maju terus Accesser ...

http://www.utteraccess.com/wiki/index.php/Myths_About_Access_FE_With_ODBC_BE

Regards
Hendra