Make a demo mde. Limit records

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Hi. I have made a pretty good database without much code
building knowledge. I would like to offer a demo version
to potential customers. I need to know, in simple terms,
how to limit the number of records a user can enter. So,
for example they can only enter 10 records maximum.
Any help would be much appreciated.
Steve
 
Hi Steve,

There are several ways you can do this here are 2:

- Design application where users can only enter information via Form and
use VBA logic to prevent X number of records being entered

- Create a table relationship in the database whereby the table has a
one-to-one relationship with another table that only has X number of records

WARNING!!! Of course any advance user of Microsoft Access would be able to
find a way around these.

I would recommend that you locate some packaging software that creates a
Trial version of your application. Do a search on the internet for
"packaging", "trial", and "software". Many of them are very inexpensive.

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights


--------------------
| Content-Class: urn:content-classes:message
| From: "Steve" <[email protected]>
| Sender: "Steve" <[email protected]>
| Subject: Make a demo mde. Limit records
| Date: Wed, 14 Jul 2004 04:39:05 -0700
| Lines: 9
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| thread-index: AcRplysjCvveZ2QzQMuBomgUJ1+5nQ==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.access.security
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.security:12097
| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
| X-Tomcat-NG: microsoft.public.access.security
|
| Hi. I have made a pretty good database without much code
| building knowledge. I would like to offer a demo version
| to potential customers. I need to know, in simple terms,
| how to limit the number of records a user can enter. So,
| for example they can only enter 10 records maximum.
| Any help would be much appreciated.
| Steve
|
|
|
 
Back
Top