Open password protected backend

[Ronald]

Hi.

I have an unprotected frontend - backend database/databases.
Now I want to put a password on the backend.
How do I get connection from the frontend to the backend and keep it till
the frontend is closed?

Thanks in advance,

Ronald.

 

[Alex Dybenko]

Hi,
you can disable shift key and do not show database window to users, so they
can't see linked tables connection string. No very secure, but database
password not very secure either

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Ronald]

That's not what I meant, Alex.

I meant secure the bank-end with a password. But how do I programmatically
connect the front-end to the back-end to be able to access the data.

 

[Alex Dybenko]

ok, I see. then you need to add at the end of connect property when you
relink tables:
;PWD=mypassword

assuming that you are using a procedure similar to:
http://www.mvps.org/access/tables/tbl0009.htm

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Ronald]

Yessss, that's it.

I looked for it in Help (TableDef.Connect) but it's not in there.

Thanks,

Ronald.

 

[Ryan]

Hi Alex,

I am new at programming and have always used the link tables manager to link
my tables. I would like to set a password on the back end of my database but
as well is there a way to set the link tables in code so that the user never
has to worry about it?? complete with the password to the back end?

Thanks for your time in advance

Ryan

 

[Alex Dybenko]

Hi Ryan,
I think you need to implement a relinking procedure, similar as on provided
link, and use it instead of link tables manager

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com