Database status flags

[sumdumgai]

Is there a place within an Access database besides a table where you can store a flag (text or boolean or number) that persists after the database is closed and can be checked when the database is opened (using VBA)?

Thanks.

 

[Minty]

Not in the Database - you could use an external file, but that doesn't offer any obvious advantage over the same data stored in a table... What are you trying to achieve?

 

[spikepl]

There are custom properties of the databse that can be created ad libitum, but as Minty said: what are you trying to accomplish?

 

[sumdumgai]

Thanks for reply. I'm importing into a database a very large text file (nearly 1GB). The file is so large that in order to refresh the database table with a new set of data (replacing old data), which is again a very large text file, I have to either delete the table or delete all of its records, do a compaction, close the database, reopen it, and restart the import. I'm trying to make this import fail proof and one way I thought of doing that was to set a flag that said that the database had been compacted and is ready for import. I can't check for non-table-existence or zero record counts because some error conditions (e.g., no table do to previous import failure) would give me a false go-ahead status. Difficult to explain, but the 'status flag' might be one way to 'gate' me through the import or block the import and force a db compact, closure, and restart.

 

[gemma-the-husky]

I often find the registry a convenient choice

savesetting/getsetting

 

[sumdumgai]

I'll just stick it in a table. Thanks for your help.