Clive Beaton
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.
If so, can someone advise me on the replacement method and how to use it.
Thanks in advance.
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?
So, what do I have to do to get the same with the new DB password method?
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.
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.
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
It was my dinosaur thinking that was undoing me.
So, for ACCDB, you really only have the (new) DB Password, which is *supposed* to be more secure than the past.
mx