Locking a database design

[Robert]

I just design a few really cool databases for my business
using Access and wish to protect the design so no one can
change the properties etc... I went into securities
looking for something that would state "secure your new
database design" or something close to that and was
confused by the language I received. I see how I could
protect the data-input but not the overall design as this
is going to be the dominate template.

In addition, can an Access template be used on a server or
in a Local Area Network application? Thankyou!

 

[Immanuel Sibero]

Hi Robert,

One of the standard practices of building an Access app probably covers your
questions:

- Split your application into two files - FrontEnd.mdb containing forms,
queries, reports, vba modules, - BackEnd.mdb containing only tables. Link
the tables from BackEnd.mdb to FrontEnd.mdb. This strategy also works great
in a network environment. Put your BackEnd.mdb on the network and distribute
the FrontEnd.mdb to each user using the application.

- If necessary, as you asked, you can convert FrontEnd.mdb to FrontEnd.mde
and distribute the mde copy to users instead. MDE is a compiled or semi
compiled format - all this means is that noone, not even you, can get into
the codes. You can do this by going to Tools>>Database Utilities>>Make MDE


HTH
Immanuel Sibero