Question Backend Db Security

[CharlesWhiteman]

My Db is split FE/BE.

On my backend am using a module which prevents shift key bypass so users cant open the Db and see the tables.

Is there a way to prevent unauthorised access to the backend. I have discovered that if I create a blank Db then I can import the tables from the BE Db.

Thanks

 

[Freshman]

Put a password on the BE.

Tools, Security, Set Database Password...

You would need to know the password to import the tbls to a new db.

There is a way around it, but every little but helps.

Also put a autoexec macro in the BE which Quits it on opening (on top of your already shift-bypass routine). Like I said every little bit helps.

 

[CharlesWhiteman]

Thanks for the reply. However, when you put a passowrd on the back end of a split database it has an effect on the fe.

I have found, which is fine, making certain ket Tbl's hidden means they dont appear if you try and link using access as the source in a another db.

 

[Freshman]

If you set the BE password first and then do the linking, you will be prompted by the FE for the password to link to the BE, but opening the FE thereafter will not prompt for a password again.
In that way you (knowing the password) will be able to open the BE, but everyone (not having to know the password) will be able to open the FE (and not the BE seperatly).

If you have to re-link the tables (via the FE) on the fly, or make on-the-fly changes to the BE via the FE, you would need to build the BE password into the code.

Hope that makes sense
Cheers
Pierre

 

[Freshman]

Forgot to add that if you name your tables stating the "USys" so eg: USysTable1 those tables will be seen as system tables and hidden (unless you make tick System Object under the Options as on)

 

[TallMan]

Any ideas where I can get the Macro that prevents shift key bypass?

 

[boblarson]

Any ideas where I can get the Macro that prevents shift key bypass?

http://www.access-programmers.co.uk/forums/showthread.php?t=36043

 

[Freshman]

Bill's PropertySetter must be the best thing since sliced bread full stop:
http://thatlldoit.com/utilsaddins.aspx