On Wed, 25 Aug 2004 01:02:23 GMT, "Tony" <ri*********@hotmail.com>
wrote:
Access (better: Jet) is not a client/server database.
To secure a Jet database you have to understand there are cheap
password crackers available. If you are not too concerned with them,
then download, study, and fully understand the Access Security FAQ
from microsoft.com. You'll learn that it is indeed possible to
disallow anyone but your application access to the back-end tables.
Personally I would not put too much value on a database design. The
commercial value is likely not in the db design, but in the
application using it. Keep the db open for your clients to access it
as well, to create ad-hoc reports etc.
-Tom.
G'day, The derivation of a (commercially valuable) relational schema has
taken me a considerable amount of time. Now I want to secure the design in
a client server environment. Hence to my question: How have developers
successfully prevented access to their data tables and protected their
database design?
Looking forward to some suggestions.
Tony