Frontend and Backend Passwords

[Tony Atack]

I know this shouldn't be too difficult but I'm really stuck.

I am running Access 2K and want to password protect my database(s) and
I don't want to go down the route of workgroups and all that as at
best it sends my head spinning.

Here's the problem, I want to use the 'Set Password' function on the
tools menu. This bit is easy, no problem works lovely. However when my
frontend attempts to get data from the backend it is locked out with
an 'incorrect password' message.

Say my two databases are called 'Frontend' and 'Backend', how do I
tell the front end to send the password (e.g.'frog') to the backend?

And that's it!! Simple eh??

 

[Joan Wild]

I take it you have opened the Backend and put a password on it via Tools,
security, set database password.

Open the Frontend, and delete all the table links. Then use File, Get
External Data, Link Tables..locate the Backend and select all the tables.
You will be prompted for the password. That's it.

You can also put a password on the Frontend.

 

[TC]

Just be aware that the back-end password will be visible in the front-end
database file, in plain text, preceeded by a well-known plaintext string. So
anyone with a simple text editor or word-processing program can get that
password in about 10 seconds

TC

 

[Tony Atack]

Many thanks, I've been drumming my head against my PC for weeks!! As
for the password being visible in the front end? I will disable the
shift key, that should stop all but the post persistent!

 

[Tony Atack]

Sorry TC, my Technical Adviser has just pointed out to me what you
meant. Kind of easy eh! Anyway 99.99999% of my users have no idea what
access is let alone how to get the password.

Once again many thanks.

TA

 

[TC]

I agree with that approach. As they say, 1% of effort will keep out 99% of
people. But no amount of extra effort, will keep out the remaining 1% of
people!

Cheers,
TC