But it sounds like you're generating tables rather than result sets.
A query to get 1000 would (hopefully) generate a result set (that looks a lot like a table, but it temporary and only tied to that user).
MS Access question
- (jbrabeck)
- (10)
- Nov. 3, 2011, 12:32:07 PM EDT
No personal experience.
- (Another Scott)
- Nov. 3, 2011, 04:32:21 PM EDT
Access isn't really multiuser
- (beepster)
- (2)
- Nov. 3, 2011, 05:48:41 PM EDT
Doesn't it have SOME piss poor locking?
- (crazy)
- (1)
- Nov. 4, 2011, 07:28:11 AM EDT
That's still a good use for it
- (drook)
- Nov. 4, 2011, 10:00:46 AM EDT
Re: MS Access question
- (altmann)
- (2)
- Nov. 3, 2011, 05:56:21 PM EDT
3 is the way
- (scoenye)
- (1)
- Nov. 3, 2011, 09:16:14 PM EDT
Yep
- (malraux)
- Nov. 3, 2011, 10:24:35 PM EDT
Haven't played with Access in a long time
- (S1mon_Jester)
- Nov. 3, 2011, 07:48:42 PM EDT
Using temp tables
- (jay)
- Nov. 3, 2011, 10:35:51 PM EDT
Additional information
- (jbrabeck)
- Nov. 4, 2011, 07:46:06 AM EDT