Protecting crucial data

[ineuw]

I have a single user DAO .MDE database application
where the calculations rely on data defined
by an external authority and it must not be altered.

To protect the data from accidental alteration,
it is my intention to imbed the data as text lines
in a module.

When the database is opened, a procedure empties
the data table and appends the contents of the text
in the module into the table.

There data consists of 62 records (rows) of 23 columns.
The data changes very rarely, and change would
involve simple text editing.

I am sure that others have come upon a similar
challenge, and my question is if there are other
methods to protect crucial data.

Thanks for any suggestions

 

[boblarson]

You could set up a constant array and access it.

 

[ineuw]

You could set up a constant array and access it.

Hi boblarson,

That is exactly what I did. I was just wondering if others have different solutions. Otherwise, the array works fine.

Thanks,

ineuw