Temporary data storage

[LucB]

When my application
- starts up, the paths to all linked backend databases are checked/renewed;
- shuts down, all linked backend databases are compacted.

Assuming I don't want to lookup the paths again at shutdown, which is the
more efficient way to preserve the path strings between startup and
shutdown:
- storage in a globally declared public array;
- storage in a temporary table (TableDef created in VBA);
- output to a temporary .txt-file?

I was thinking 'efficient' both in terms of memory usage and speed, but
other considerations welcome.

 

[Allen Browne]

The simplest way to get the linked path of an Access (Jet) table would be:
Mid(CurrentDb().TableDefs("Table1").Connect, 11)