Test Version of Access Application

[Guest]

I want to design a test version of MS Access Application, e.g., For a limited
period or limited uses. Is it possible using VBA or someting else?

 

[Rick Brandt]

I want to design a test version of MS Access Application, e.g., For a
limited period or limited uses. Is it possible using VBA or someting
else?

Demos based on time or date are easily manipulated by messing with the system
clock on the PC. It is more reliable to make no time limit but set a validaton
rule on a key table or tables that limits the number of rows that they can hold.

For example if you had a table with an incrementing AutoNumber field that also
had a validation rule of <1000 on that field then the table would stop accepting
new records after the AutoNumber hit that threshold.

Another convenience is that you can set the validation text to something like...
"You have reached the limits of this demo version." so that the error
encountered is self explanatory and all with no code required.