User-Specific WorkTables: How to handle MakeTable queries?

[Joan Wild]

I misread I guess. I thought you were puttint the temp mdb in each user's
folder, rather than the All Users folder.

 

[Douglas J Steele]

Per Dirk Goldgar:

Doesn't that tend to bloat the application?

Tony Toews talks about it at http://www.granite.ab.ca/access/temptables.htm
His experience is that it adds about 5 Kb.

 

[Dirk Goldgar]

Per Dirk Goldgar:

Doesn't that tend to bloat the application?

A small amount, but nothing compared to keeping the work tables local.
Most database operations grow the database a small amount, in my
experience.

 

[(PeteCresswell)]

Per Joan Wild:

I misread I guess. I thought you were puttint the temp mdb in each user's
folder, rather than the All Users folder.

I was. Never thought about the All Users folder. That would have saved a lot
of coding - as long as there isn't any permission problem as there sometimes is
when trying to create/write to C:\Temp.