By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,204 Members | 1,212 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,204 IT Pros & Developers. It's quick & easy.

back end connection string

P: 68
I have a split access 2003 db where I am not using the built-in user level security in the FE (long story) but do want to password protect the BE in the normal way. If I set a password for the BE, when I open any form in the front end I get an error as the BE password is needed to access the linked tables data.

Could anyone show me an example of the connection string that I'd need (and where it should go) so that I can pass the BE password. I think that's what I need to do isn't it? And would this have to be run for every instance where data is being accessed, or would it just be run when first opening the FE? I'm fairly okay at understanding how code works once I've seen an example but I've never used connection strings and just can't get my head around the help file examples!
Sep 12 '07 #1
Share this Question
Share on Google+
2 Replies


P: 68
I feel sooo stupid.... I have spent hours and hours trying to resolve this and just now had the necessary brain wave;

the solution, for anyone else who's ever tried this, is to split the db, set a password on the BE, re-open the FE and delete all the table links, then relink the tables. From there on the BE password is magically embedded somewhere in the mix.
Sep 12 '07 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
I feel sooo stupid.... I have spent hours and hours trying to resolve this and just now had the necessary brain wave;

the solution, for anyone else who's ever tried this, is to split the db, set a password on the BE, re-open the FE and delete all the table links, then relink the tables. From there on the BE password is magically embedded somewhere in the mix.
LOL!

We've all been there Kevin. Glad you figured it out.
Sep 12 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.