prevent from linking tables

[Song Su]

Access 2007

Is it possible to prevent user from creating a blank database and
link/import my backend tables?

Thanks.

 

[Douglas J. Steele]

Of course, there are many free (or cheap) password recovery utilities out
there...

 

[Keith Wilby]

Hi Douglas,

Sorry I didn't realize it was so easy to hack. What would your suggestion
be?

I would say that your suggestion is perfectly fine so long as the OP is
aware of the limitations. You have to assess the risk of someone in your
organisation being a hacker. Where I work, such hacking would be a
disciplinary matter so the risk is very low.

Keith.
www.keithwilby.com

 

[Keith Wilby]

You don't have an alternative suggestion?

If you insist: use Oracle.

Keith.

 

[Douglas J. Steele]

There isn't really one for Access (or any other file-based DBMS where the
user must have access to the file).

As Keith implies, the only reliable approach is to use a server-based DBMS
that has appropriate security. Note that this does NOT mean you can't still
use Access as the front-end!

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Hi Douglas,

Sorry I didn't realize it was so easy to hack. What would your suggestion
be?


Bonnie

http://www.dataplus-svc.com

Of course, there are many free (or cheap) password recovery utilities out
there...

Put a password on your backend. They can't link to it if they don't
have
the

[quoted text clipped - 10 lines]

Thanks.

 

[Keith Wilby]

Thanks, I was naive but Access is secure enough for my current uses. If
you
have a user that wants to go to that much trouble to get in - well, I
don't
know, bummer!

You can protect your code somewhat by making your FE file an mde.