Lee-
Yes, you can limit the records added by putting code in the BeforeInsert event
of all relevant forms. If running in "trial" mode, cancel the insert when the
user tries to add the "nth + 1" record. You usually have to do this only for
the "root" table of your relationships. Let's say you have a typical order
entry database: Customers -> Orders -> OrderDetails <-Products. A limit on
Customers and Products would also restrict how many different Orders and
OrderDetails could be entered.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Lee Nicholas
Sent: Wednesday, November 30, 2011 1:42 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Create a Demo Copy
John
That does help. Also read that you can limit the number of record entries would
that work as well?
Not sure what the code would be.
I'm a novice at this stuff.
Lee
----- Original Message -----
From: John Viescas<mailto:john@viescas.com>
To:
MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogrou
ps.com>
Sent: Tuesday, November 29, 2011 12:59 PM
Subject: RE: [MS_AccessPros] Create a Demo Copy
Lee-
Well first, you have to build a "locked down" application that disables the
Shift key (set the AllowBypassKey property) and distribute only an MDE file
that
has startup properties set correctly. Then, you have a couple of options:
1) Write the first open date and today's date to a "hidden" table and then
check
it on each startup
2) Write a registry key that you check on startup
Either method can be broken by a really smart user. In your startup code,
you'll also need to check to see if the user has set back the clock by
checking
both the first open and last startup dates.
Hope that helps...
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/<http://www.viescas.com/>
(Paris, France)
-----Original Message-----
From:
MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogrou
ps.com>
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Lee Nicholas
Sent: Tuesday, November 29, 2011 7:54 PM
To:
MS_Access_Professionals@yahoogroups.com<mailto:MS_Access_Professionals@yahoogrou
ps.com>
Subject: [MS_AccessPros] Create a Demo Copy
I just joined so sorry if this question has been asked before.
Any input on how to limit the use of a demo copy?
Working in Access 2003.
Thanks
Lee Nicholas
------------------------------------
Yahoo! Groups Links
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar