Can a split database have different passwords for Front and Back-end?

[Edo2008]

If they are promted for it, then they'll have to know it. I do NOT
want them to know it. if they know it, they can access the back-end
by hand.

For some reason I'm not making myself clear. Sorry.

From the code you showed above, it looks like I just have to modify
the password and write the values back into the "Connect" property of
each table and that's it. One time. I asumme this'll work.

-Ed

 

[strive4peace]

Hi Ed,

you do NOT want to save the password in tables that will always be
connected; this is a security breech. That is why I suggested you
disconnect and reconnect -- but even this has its flaws... they may exit
unproperly

If you are that concerned about protecting the data, you could connect
to tables at the time they are needed if connections do not already
exist. You can also make the connected tables 'hidden'

you could also write a routine to encrypt and decipher the data

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*

 

[aaron.kempf]

this linking crap is a total waste of time.
you would be much better off with ADP, then you would just need to put
the password in a SINGLE LOCATION