Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
qwertyjjj
Posting Yak Master
131 Posts |
 Posted - 2007-10-17 : 03:55:58
|
| Is it possible to trace if DLookup is used on Access and how this affects the SQL server?I presume the JET engine translates it to SQL somewhere?Am just worried that it's hitting the database hard by looping through records and doing table scans. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-20 : 00:48:00
|
| Possible if hits sql db. |
 |
|
|
|
|
|
profiler trace of Access' DLookup