Locking up a Form Table

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

--
After searching Google.groups.com and finding no answer, Bob Vance asked:

Is there a way of locking up a from tables with a code so as anybody that
copies my software cant change the Company Details input data form, newbie
thanks
Thanks in advance.........Bob Vance
 
If I properly understand your question, you want to secure your database
application so the design cannot be changed. Applying Access Security, so
that you are the only one with design permissions would be one way -- Access
Security is non-trivial. If you simply want to protect the Forms, Reports,
and Modules, you can make an MDE -- but that will leave the Tables, Queries,
and Macros open to change.

Larry Linson
Microsoft Access MVP
 
Thanks Larry, Where do I find the information for making a MDE?
Click to expand...

In the online Help for one thing: search for "About MDE Files".

Tools... Database Utilities... Convert Database; select "To MDE file".

The database must be converted to the Access version you're using (for
example, if you're using AccessXP and the database is in the default
2000 format you'll need to first convert it to 2002 = XP); and you
must compile all the VBA code and remove any compile errors.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
My version is 2002 but this software was written on another machine does
that matter??
thanks Bob Vance
 
Back
Top