Sometimes faster just to import the whole table
and ditz with it locally from there. Access tends to go overboard on the locking as well, which can cause its own set of problems.
|
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