Demo Solution

[Andy6]

I want to make a demo version of my database solution and I thought that a
version where the maximum number of records in any of the tables was, say 10.
does anyone know if this is possible. or a better idea as a demo version.
Appreciate your ideas.
Andy.....

 

[RoyVidar]

I want to make a demo version of my database solution and I thought
that a version where the maximum number of records in any of the
tables was, say 10. does anyone know if this is possible. or a
better idea as a demo version. Appreciate your ideas.
Andy.....

Tony Toews has a good article http://www.granite.ab.ca/access/demo.htm

There should also be something to find if you search these groups, as
this has been discussed.

Else, not necessarily a better idea, but using ADO, you can use CHECK
constraints to limit the number of records, too - for instance
something
like this (untested):

currentproject.connection.execute _
"ALTER TABLE myTable ADD CONSTRAINT ch_max_num_of_records " & _
"CHECK (10 >= SELECT Count(*) FROM myTable))"

In this article, there's a bit more about methods like that
http://msdn2.microsoft.com/en-us/library/aa140015(office.10).aspx

Without additional security on the database, it wouldn't be very
secure,
but this feature isn't used by many Access developers (who mostly
favour DAO over DDL/ADO), so it could pose a challenge to break ;-)

 

[Andy6]

Thanks Roy youv'e given me some things to think about. but for now I will
probably continue with my thirty day bomb in the main forms open event, but I
will keep working on different solutions.
Thanks for answering
Andy....