Does ACCESS support an Array of the same Table?

[DaveK]

Hi,

I understand Access databases and use them often via VBA.

What I am needing is for access to support a ARRAY of TABLES which I can programmatically access via VBA.

I want to save a certain TABLE every month, and be able to read that table as needed. I could save this certain TABLE every month, but it would need a unique name and over time there would be a lot of these tables, one for each month.

What I want to have is something like TABLE_OF_NAMES (n), where each index represents a complete valid Access table, all with the same exact structure. I cant seem to read or find anything that Access supports table arrays.

also: Does Access support FOLDERS to put desired TABLES into? (in case I have to do it this way)... or would all these tables just pile up in a big flat pile?

Any ideas?

Thanks so much.
Dave

[Imdabaum]

By table array, are you referring to multi-dimentional arrays? If so, yes it does.

Access also supports exporting your tables into a flat file that you could store in a folder, sure. Doing this for every month is going to give you a lot of flat files in the long run, but if you need the data and don't want it in your database, then I suppose you could do it.

If you really wanted, I guess you could even dynamically link to the text file later on if you wanted to access the data again.