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.

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.

mx

Clive Beaton

ASKER

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.

Then:
1) Unlink your tables from backend
2) Add password to backend
3) Relink, supplying password during linking process.

Clive Beaton

ASKER

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.

ASKER CERTIFIED SOLUTION

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Clive Beaton

ASKER

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

It was my dinosaur thinking that was undoing me.