Using temp tables
If your using a recent version of MS Access you can use SQL temp tables if you setup your queries as stored procedures. See http://support.microsoft.com/kb/287728. Each user should get their own set of temp tables, but I have never tried it myself.
Jay |
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