how to restrict a table to 10 records

[goodhead]

I want to build a demo db and make it so the user cant add more than 10 records.

perhaps a popup when trying to save the 11th

any ideas?

 

[David R]

Look into the DCount function.

 

[MarkK]

You are battling obscurity, not theft.

My 2c is that it's a newby mistake to think your software is so awesome that people are going to steal it. Trust your customer. Show your customer that trust. That'll be worth more money than you'll ever lose to theft.

Your customer is going to need to trust you to show you all their sensitive data. Start that relationship off on the right foot and trust them first.

Give your customer a full featured demo. Let them really see how it's going to help them. Show them that you totally care about generously solving THEIR problems, not stingily protecting your own interests.

My 2c,

 

[goodhead]

Re: You are battling obscurity, not theft.

My 2c is that it's a newby mistake to think your software is so awesome that people are going to steal it. Trust your customer. Show your customer that trust. That'll be worth more money than you'll ever lose to theft.

Your customer is going to need to trust you to show you all their sensitive data. Start that relationship off on the right foot and trust them first.

Give your customer a full featured demo. Let them really see how it's going to help them. Show them that you totally care about generously solving THEIR problems, not stingily protecting your own interests.

My 2c,

I have a full working db which I hope to sell for a couple a quid. The demo is not to stop theft but just a demo of what the full version does. Theres no point giving them a full demo as that makes my main one pointless.

A taster!!

 

[Pat Hartman]

I would use an autonumber primary key. Make sure the seed is reset to 0 in your distribution copy. Then add a validation rule that the PK field must be < 11. No code. Let the database engine do the work.