I've worked in aerospace manufacturing quality systems and auditing for years and I have developed a access database system that has really benefited companies to save a lot of money. I would like to allow companies to use the one I have developed for free and integrate it into their system.
That being said, after they have inputted so many records, I would like the database to max out and remind them that they have to pay for it (they would already be aware of this upfront) if it's working for them.
Is there any way that once the primary key field (autonumber) has reached a certain point it will not allow them to enter any new records? Or, perhaps I could limit the date of entry (mm/dd/yyyy) to not go beyond six months or so?
I think it would be easier to let them try it out and decide rather than having to commit upfront. Do you have any recommendations?
Obviously, I would have to limit access to the navigational pane so they can't edit queries, tables, etc. Controls will be limited to what is in the switchboard. Any recommendations?