how to secure the BE?

[Guest]

I want to split the db, mde the FE and replicate the BE and put both local on
the same PC. I belive the FE would be pretty locked up, but what about the
BE- how do I keep users from importing tables from it or even opening it in
design view and messing with things?

thanks

 

[Joseph Meehan]

I want to split the db, mde the FE and replicate the BE and put both
local on the same PC. I belive the FE would be pretty locked up, but
what about the BE- how do I keep users from importing tables from it
or even opening it in design view and messing with things?

thanks

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.

 

[Guest]

MANY THANKS!

I want to split the db, mde the FE and replicate the BE and put both
local on the same PC. I belive the FE would be pretty locked up, but
what about the BE- how do I keep users from importing tables from it
or even opening it in design view and messing with things?

thanks

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.

 

[dbahooker]

Access MDB is impossible to secure
Dont use it for a single record and a single user.

it's not reliable, it's not secure. it's not acceptable

don't listen this ****er from Europe; if he was halfway smart; he would
have immigrated to a real country a long time ago


-Aaron

I want to split the db, mde the FE and replicate the BE and put both
local on the same PC. I belive the FE would be pretty locked up, but
what about the BE- how do I keep users from importing tables from it
or even opening it in design view and messing with things?

thanks

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can easily lock
you out of your database, which might require the paid services of a
professional to help you get back in.

Practice on some copies to make sure you know what you are doing.

 

[Joseph Meehan]

Access MDB is impossible to secure
Dont use it for a single record and a single user.

it's not reliable, it's not secure. it's not acceptable

don't listen this ****er from Europe; if he was halfway smart; he
would have immigrated to a real country a long time ago


-Aaron

Thanks. Coming from you that is a real compliment.

 

[dbahooker]

eat shit

if you had enough intelligence we would grant you a visa to come to a
real country