Relink Database with Common File Dialog in Access 2007 w/Password Protection

[padlocked17]

All -

Just as the title describes, I can't seem to find a solution to be able to link the front-end to the back-end tables through the common file dialog when the backend is an accdb file that is password encrypted.

See the example attached. Here it should work just fine per the Article at :

http://support.microsoft.com/kb/181076

I've found it works fine without a password encrypted back-end but not with a password encrypted back-end.

Anyone have any ideas? It would be nice to use this feature in Access as well as automating the relinking.

Thanks!

 

[padlocked17]

Along with the help of Alan Cossey, I was able to successfully integrate the vPPC security method which essentially allows for Group Level permissions on a database in the accdb/r/e formats. Really cool little application. It has a Security application (Access DB) that allows for permissions to be set and then a secured back-end that allows for all data to be stored common for each front-end distributed. As long as the Front-End is placed in the same spot on each user's computer, it works flawlessly. I've just packaged it using the Developer Extensions and I now am able to keep the data in a networked back-end, the queries in a Mid-Tier location (This can be bypassed) and the Forms in a Front-End database. Group level securities allows me to use the Windows username to grant individuals certain permissions containted within a group and all is good.