limiting number of records

Hi, I looking to put a limit on the number of records a person can enter into
the program.
I want to use it as a demo version to give clients a look at the program and
limit the number of entries they can enter.
not sure eon the code and where i would enter it.

Would it go into the form before update?
thanks for any help

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200910/1

Anything you do, you'll need to secure, or your users can change it.

The easiest way to limit records is to set a validation rule both in the
table and in the form. If you want to limit the records to 10, use an
Autonumber field as the primary key, and set the validation rule to:

=10
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Miami5 via AccessMonster.com" u52885@uwe wrote in message
news:9d755a3da5a95@uwe...
Hi, I looking to put a limit on the number of records a person can enter
into
the program.
I want to use it as a demo version to give clients a look at the program
and
limit the number of entries they can enter.
not sure eon the code and where i would enter it.

Would it go into the form before update?
thanks for any help

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200910/1

Thanks, how can i go about securing the information

Arvin Meyer [MVP] wrote:
Anything you do, you'll need to secure, or your users can change it.

The easiest way to limit records is to set a validation rule both in the
table and in the form. If you want to limit the records to 10, use an
Autonumber field as the primary key, and set the validation rule to:

=10
Hi, I looking to put a limit on the number of records a person can enter
into
[quoted text clipped - 6 lines]
Would it go into the form before update?
thanks for any help

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200910/1

Security is not trivial. Here's what you need to know:

Security FAQ
http://support.microsoft.com/downloa...les/SECFAQ.EXE

Lynn Trapp's summarization:
http://www.ltcomputerdesigns.com/The10Steps.htm

KB articles:
http://support.microsoft.com/default...;en-us;q165009
http://download.microsoft.com/downlo...-us/secfaq.exe
http://support.microsoft.com/default.aspx?kbid=325261

Joan Wild's articles:
http://www.jmwild.com/security02.htm
http://www.jmwild.com/security97.htm
http://www.jmwild.com/SecureNoLogin.htm
http://www.jmwild.com/Unsecure.htm
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Miami5 via AccessMonster.com" u52885@uwe wrote in message
news:9d7cd1f46c740@uwe...
Thanks, how can i go about securing the information

Arvin Meyer [MVP] wrote:
Anything you do, you'll need to secure, or your users can change it.

The easiest way to limit records is to set a validation rule both in the
table and in the form. If you want to limit the records to 10, use an
Autonumber field as the primary key, and set the validation rule to:

=10
Hi, I looking to put a limit on the number of records a person can enter
into
[quoted text clipped - 6 lines]
Would it go into the form before update?
thanks for any help

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200910/1

Security is, indeed, not trivial. And, it depends on how complex the database
id, of course, but for\ a given form/table:

Private Sub Form_Load()
DoCmd.GoToRecord , , acLast
DoCmd.GoToRecord , , acLast
End Sub

Private Sub Form_Current()

Dim MaxRecs as Long

MaxRecs = 100

If Me.RecordsetClone.RecordCount MaxRecs Then Me.AllowAdditions = False

End Sub

This limits the number of records to 100. Now simply convert the Mdb file to
an Mde file and distribute it and the code won't be accessible to the end
user so modification won't be possibe.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com