Demo Solution

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andy6 - 31 Mar 2007 10:50 GMT

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.....

Reply to this Message

RoyVidar - 31 Mar 2007 11:18 GMT

"Andy6" <Andy6@discussions.microsoft.com> wrote in message
<051BEA05-C03E-48E8-AB6E-3941697328AA@microsoft.com>:

> 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 ;-)

Signature

Roy-Vidar

Reply to this Message

Andy6 - 31 Mar 2007 21:14 GMT

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....

Reply to this Message