Avatar of Clive Beaton
Clive Beaton
Flag for Australia asked on

How do I use a password protected Back End database?

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.
Microsoft Access

Avatar of undefined
Last Comment
Clive Beaton

8/22/2022 - Mon
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

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.

Clive Beaton

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 - Former Microsoft Access MVP)

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.

1) Unlink your tables from backend
2) Add password to backend
3) Relink, supplying password during linking process.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
Clive Beaton

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.
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Clive Beaton

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

It was my dinosaur thinking that was undoing me.