Why does something this simple, take soo long? - (folkert) - (21) - Dec. 7, 2004, 02:27:17 PM EST
         Probably at the Access level - (JayMehaffey) - (1) - Dec. 7, 2004, 03:10:19 PM EST
             Doesn't matter either way. - (folkert) - Dec. 7, 2004, 05:37:39 PM EST
         Investigate Pass-Through Queries in Access -NT - (altmann) - (1) - Dec. 7, 2004, 04:35:46 PM EST
             Thanks. I do that later. - (folkert) - Dec. 7, 2004, 05:39:12 PM EST
         Latency between Access and SQL Server - (ben_tilly) - (2) - Dec. 7, 2004, 05:13:12 PM EST
             That is just WRONG. - (folkert) - Dec. 7, 2004, 05:40:00 PM EST
             Sometimes faster just to import the whole table - (ChrisR) - Dec. 7, 2004, 05:53:08 PM EST
         I would ask for a showplan - (Simon_Jester) - (1) - Dec. 7, 2004, 05:25:51 PM EST
             There is an osql - (altmann) - Dec. 7, 2004, 06:43:59 PM EST
         The answer is in the first line of your post -NT - (tuberculosis) - (1) - Aug. 21, 2007, 06:34:31 AM EDT
             Clever, cleaver, thine art. -NT - (folkert) - Dec. 8, 2004, 01:02:49 PM EST
         Most questions that start, "why does Access......?" - (tablizer) - (9) - Dec. 22, 2004, 05:17:20 PM EST
             That might change. - (inthane-chan) - (8) - Dec. 22, 2004, 05:38:40 PM EST
                 Not unless VB is integrated with SQL server - (ben_tilly) - (7) - Dec. 22, 2004, 06:28:24 PM EST
                     Yeesh! - (inthane-chan) - (4) - Dec. 22, 2004, 06:47:37 PM EST
                         That trick is actually useful..ugly, but useful -NT - (ben_tilly) - (3) - Dec. 22, 2004, 07:50:13 PM EST
                             The poor man's Control Tables -NT - (ChrisR) - (2) - Dec. 22, 2004, 07:57:27 PM EST
                                 That's one thing to use it for -NT - (ben_tilly) - Dec. 22, 2004, 08:40:28 PM EST
                                 Files systems are not much better. Trees too damned limited -NT - (tablizer) - Dec. 26, 2004, 03:24:20 AM EST
                     Perish the thought - (ChrisR) - Dec. 22, 2004, 07:06:12 PM EST
                     "In the Next Version" - (altmann) - Dec. 22, 2004, 08:01:26 PM EST