locking a DB for demo purposes

[^Halibut^]

i have a application using VBA and Access DB. can i limit the # of records
in the tables to lock the app for demo purposes? the DB is password
protected

thanks

 

[John Vinson]

i have a application using VBA and Access DB. can i limit the # of records
in the tables to lock the app for demo purposes?

One sneaky way is to put a Validation Rule on a numeric (e.g.
autonumber) primary key of

0 AND <= 100

to limit the table to 100 records (or fewer if the autonumber has
gaps).

the DB is password protected

Just be aware that there are plenty of websites which offer tools to
crack simple password protection; it's about as secure as a $8.95 bike
lock. I'd strongly recommend at least reading the Microsoft Security
FAQ and properly securing the database with workgroup security; it can
be cracked but it's a lot more work.

 

[Tom Wickerath]

Hi John,

Neat idea, but I don't see that a Validation Rule is available for an Autonumber data
type. It is available for a Number data type, but then you'll still have to "roll your
own" (code, that is) in order to make it work.

_________________________________________________

i have a application using VBA and Access DB. can i limit the # of records
in the tables to lock the app for demo purposes?

One sneaky way is to put a Validation Rule on a numeric (e.g.
autonumber) primary key of

0 AND <= 100

to limit the table to 100 records (or fewer if the autonumber has
gaps).

the DB is password protected

Just be aware that there are plenty of websites which offer tools to
crack simple password protection; it's about as secure as a $8.95 bike
lock. I'd strongly recommend at least reading the Microsoft Security
FAQ and properly securing the database with workgroup security; it can
be cracked but it's a lot more work.

 

[cTaHk0]

Hi Tom,
Yes it is available just click on properties when you on that field

regards,
cTaHk0

 

[Van T. Dinh]

You can use the Table Validation Rule instead of the Field Validation Rule.

 

[Van T. Dinh]

Tony Toews has a number of ideas in his article:

http://www.granite.ab.ca/access/demo.htm