No coding involved here, but a very curious problem:
I have some Access 2010 databases I have to secure, and currently I have a spreadsheet with queries to get their data. When I encrypt one database with a password and close it, I then open an Excel query pointing to it, save the password into its connection string, and then refresh. But it asks for the password anyway -- repeatedly! The only way out is to hit Cancel, after which, obviously, it doesn't pull in data.
I understand there's no more user-level security as of Access 2007, so am I supposed to downgrade to 2003 format to get that? In general, how do I secure an Access 2010 database such that I can get its data into Excel only if I know its password?
I have some Access 2010 databases I have to secure, and currently I have a spreadsheet with queries to get their data. When I encrypt one database with a password and close it, I then open an Excel query pointing to it, save the password into its connection string, and then refresh. But it asks for the password anyway -- repeatedly! The only way out is to hit Cancel, after which, obviously, it doesn't pull in data.
I understand there's no more user-level security as of Access 2007, so am I supposed to downgrade to 2003 format to get that? In general, how do I secure an Access 2010 database such that I can get its data into Excel only if I know its password?