Locking up a Form Table

[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

 

[Larry Linson]

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

 

[Bob]

Thanks Larry, Where do I find the information for making a MDE?
TIA Bob

 

[John Vinson]

Thanks Larry, Where do I find the information for making a MDE?

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

 

[Bob]

John where do I find what version my access data base is in, thanks Bob

 

[John Vinson]

John where do I find what version my access data base is in, thanks Bob

Select Help... About from the menu.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Bob]

My version is 2002 but this software was written on another machine does
that matter??
thanks Bob Vance

 

[John Vinson]

My version is 2002 but this software was written on another machine does
that matter??

The other computer must have either Access 2002 or 2003 to run this
..mde file. 2000 or earlier will not be able to use it.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps