locking a DB for demo purposes

  • Thread starter Thread starter ^Halibut^
  • Start date Start date
H

^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
 
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?
Click to expand...

One sneaky way is to put a Validation Rule on a numeric (e.g.
autonumber) primary key of
0 AND <= 100
Click to expand...

to limit the table to 100 records (or fewer if the autonumber has
gaps).
the DB is password protected
Click to expand...

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.
 
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?
Click to expand...

One sneaky way is to put a Validation Rule on a numeric (e.g.
autonumber) primary key of
0 AND <= 100
Click to expand...

to limit the table to 100 records (or fewer if the autonumber has
gaps).
the DB is password protected
Click to expand...

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.
 
Hi Tom,
Yes it is available just click on properties when you on that field :)

regards,
cTaHk0
 
Back
Top