deploying a password protected backend (1 Viewer)

[accessuser1023]

All,

I have to do this and I believe there is VBA code to re-link tables when needed that can be found on the web. My client needs access to everything because he will move on to another developer after this, so what I thought I would do is send him a private file that has the password for the backend and then just write the ADO code needed in the app's front end to connect with the password.

Can anyone comment on this strategy at all? This sounds right to me. I just usually copy code from the web and use it if I don't already have it.

thanks!

 

[pr2-eugin]

I hope you are looking for Relink ODBC tables from code.

 

[accessuser1023]

thank you Paul. That will do fine. What I'm really looking for more than anything though is advice on whether what I'm going to do is really worth the effort. The person on the other end really knows nothing at all. That includes servers, etc...

So how much frustration is it to me?