Password BE Database

  • Thread starter Thread starter Richard Krupa
  • Start date Start date
R

Richard Krupa

Hi everyone,

If i password protect the BE databases what do i need to do with the FE to
allow them to still be able to connect to the password protected BE
databases?

Also i have code that relinks tables, in the reconnect string, where do i
provide the password for the BE?

Hope this all makes sense
 
If you want real security, I suggest using workgroup security, not a
simple password.

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 lock
everyone including God out.

Practice on some copies to make sure you know what you are doing.
 
Joseph Meehan said:
If you want real security, I suggest using workgroup security, not a
simple password.

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 lock
everyone including God out.

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

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math


Richard Krupa said:
Hi everyone,

If i password protect the BE databases what do i need to do with the FE to
allow them to still be able to connect to the password protected BE
databases?

Also i have code that relinks tables, in the reconnect string, where do i
provide the password for the BE?

Hope this all makes sense
 
Replies inline below

Richard Krupa said:
Hi everyone,

If i password protect the BE databases what do i need to do with the FE to
allow them to still be able to connect to the password protected BE
databases?

Just make sure you supply the password when you initially Link the BE
tables. Once they are linked, the password will be saved with the link
information in the Connect string.
Also i have code that relinks tables, in the reconnect string, where do i
provide the password for the BE?

It goes after the "PWD=" parameter. Here is a sample connect string:

MS Access;PWD=mypasswd;DATABASE=R:\Data\MyDB.mdb

You can see exactly what the Connect string should look like for your app.
After manually linking the tables, bring up the Debug window (Ctrl-G) and
type in:

?CurrentDb.TableDefs("any_linked_table_name").Connect

and hit Enter. Set the TableDef's Connect property to that string, then call
the TableDef's RefreshLinks method in your code relinker.
 
Almost forgot: Even with a password on the BE, a person could still load the
..MDB into a text editor like TextPad and see the data, albeit unstructured.
If you're worried about this scenario, you could also Encrypt the BE - then
it would be gibberish in a text editor, too.
 
Back
Top