temporary tables in DAO

[Douglas J. Steele]

Not sure I understand what your code is supposed to be doing, nor what
situation you're describing.

However, if you're getting the results you want, presumably it works.

 

[PC Datasheet]

Tracy,

Are you aware that creating and deleting temp tables will bloat your
database quickly. You might want to consider a different solution.

 

[Douglas J. Steele]

I did mention that in my first post to this thread, Steve:

"If you're creating a temporary table, you're better off creating it in a
temporary database, to avoid bloating in your real database. Tony Toews has
an example at http://www.granite.ab.ca/access/temptables.htm"

 

[Guest]

The code was for calling the function...

Thanks.

 

[Guest]

Thanks. I'll check it out.

Tracy,

Are you aware that creating and deleting temp tables will bloat your
database quickly. You might want to consider a different solution.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

 

[Guest]

Douglas, I'm sure I need to read more about all this but I did create a temp
database and the temp table is made in the temp database but the module is in
my real database and I have my table linked to the temp. That should avoid
any bloating, correct? Or did I do something incorrectly?
Thanks.

Tracy

 

[Douglas J Steele]

There will be a little tiny bit of bloating caused by repeatedly creating
and deleting the linked table, but there's not really anything you can do
about that. It shouldn't be a problem.

 

[Guest]

Yes, I can periodically compact it. I sure appreciate all your support.

Tracy