Dated tables

[PigVetTech]

I'm not sure if this is possible but it seems like it
should be.

We're working on a flash based tutorial cd. Since most of
the users would be rurally based, it needs to be on a cd
because it's highly graphic and narrated. We have the
flash set up and with an asp file to connect to it. What
we would like to do is to set up a database with tables
that are time dated. A user would exist in a table (other
than the main table) for a week after the first time he
accessed the module.

Here's how it would work:
1. We add user to the main table.
2. User would access module for the first time. His /
her info would then be automatically dated.
3. User would remain on this table for 7 days
4. User's name would drop off the table on the 8th day.
(the module would no longer be able to access the
database)

Can someone help me or point me to somewhere that has the
answer?

Thanks

 

[Kevin3NF]

How about adding the user also populates an "expirationdate" field. When he
tries to logon, check the expiration date vs. the system date, and do
whatever you need from there...

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.