How do I use a password protected Back End database?

Clive Beaton
Clive Beaton used Ask the Experts™
on
In earlier versions of Access, I used an MDW to use a secured back end database.  I understand that method is not used in MS 2010.  Is that right?

If so, can someone advise me on  the replacement method and how to use it.

Thanks in advance.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
Correct ... ULS not supported in the ACCDB format as of A2007. BUT ... is still supported with MDB format running in A2010.

So, for ACCDB, you really only have the (new) DB Password, which is *supposed* to be more secure than the past.

mx
Clive BeatonAccess Developer

Author

Commented:
Thanks.  So, in previous versions starting the program with the mdw in the shortcut was all that was required and set db = currentdb() just worked.

So, what do I have to do to get the same with the new DB password method?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
Top Expert 2007

Commented:
So, you will be using the ACCDB format then ?  Have you already converted ?  

Seems that ... you would Remove ULS (I can send a KB link) from the original MDB, the convert.

Then:
1) Unlink your tables from backend
2) Add password to backend
3) Relink, supplying password during linking process.
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Clive BeatonAccess Developer

Author

Commented:
I didn't have to covert an mdb.  I created the BE accdb from new.

So, I have an unsecured accdb as the back end, so if I understand you correctly, I don't have to unlink/relink to remove the ULS.

Do I have to unlink/relink to the BE each time the FE is started, in order to provide the password?   If so, would that mean that set db = CurrentDb would then work?

I have the feeling that I'm completely missing the point.
Database Architect / Application Developer
Top Expert 2007
Commented:
"Do I have to unlink/relink to the BE each time the FE is started, in order to provide the password?   "
No.  The password will be stored in the connection string.  OR ... if you have auto relinking in code, then you can have the password hard coded.

Not sure what you are asking about Set DB = CurrentDB ?

mx
Clive BeatonAccess Developer

Author

Commented:
Sensational!  Thanks very much.  (I was just about to go out and slit my throat.)

It was my dinosaur thinking that was undoing me.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial