Limit to Number of Tables

In order to facilitate the export of data to Excel, I will be creating tables, appending data to these tables, exporting to Excel and then killing the tables. Is there a limit to the number of tables that can be created over the lifetime of a database, even if those tables are ultimately deleted?

Thank you for your help.

No, I don't think so. However, this can bloat the database, requiring
frequent compacting. One thing I do to avoid this is programmatically
create a temporary DATABASE, create tables there, link them into my
application, do my importing, then kill the whole temp database.

On my website (see sig below) is a small sample database called
"ImportToTempDatabase.mdb" which illustrates how.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org


"T'Kai" wrote in message
...
In order to facilitate the export of data to Excel, I will be creating
tables, appending data to these tables, exporting to Excel and then killing
the tables. Is there a limit to the number of tables that can be created
over the lifetime of a database, even if those tables are ultimately
deleted?

Thank you for your help.