Microsoft Access ADO
Enable Microsoft Access ADO 2.x Connections to SQL Azure.
Yes please.. Although I'm open to documented coding methods building upon was is already implemented by many would save resources for alot of folks...
Ole Henrik Oftedal commented
I vote Yes
Danny chen commented
This could be the best thing ever
We have a comprehensive erp system need on access adp
If we can connect to azur using ado , all our 520 tech and field engineers
Can provide best field service
We are microsoft partners for 10 years
President and owner
Secure is better
ado 2 might be a bit out of fashion, but being able to use it to create secure connections between sql azure and Access would be a major help for us as we develop custom solutions for various companies. sql azure would serve us well as the main datastore for many of our Access apps; but because of the transparency of the connection strings, we can't consider it. Microsoft please help with this...we'd like to create many more sql azure based solutions but this is a major obstacle.
Roger Jennings commented
Definitely a necessity.
"Microsoft Access 2010 In Depth"
Pat Wood commented
This will enable more secure connections to SQL Azure and provide additional functionality. ODBC linked tables and queries expose your entire connection string including your server, username, and password.