Newbie. Password exchange between front and back end. 1

[Plumes]

Hi All

I am currently using some code from a thread I found on here to on open check the links between the front end (forms etc.) and the back end (tables). If it can't find the links it asks the user to find the back end. This works fine.

I need to password the back end of the db, but still allow the relink operation to work without the user needing the password. Is there some way the front end can hold and supply the password for the back end when necessary??????

Matt.

 

[DaOtH]

Matt,

Use something like the following :
Set dbBackend = OpenDatabase(strBackend, False, False, "; pwd=" & strPassword)



"In three words I can sum up everything I've learned about life: it goes on."
- Robert Frost 1874-1963

 

[Plumes]

DaOtH,

Thanks that worked brilliantly!

Matt