You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
Today’s guest writer is Greg Lindhorst, the person looking into how to improve Access and SQL Server for Access 15.
Hello everyone! As Office 2010 nears shipping, we are starting to plan Office 15. One area that we are considering improving is our SQL Server support. Based on what I've heard from the community, that would be most welcome. Note that we are very early in planning, and considering many possible areas of investment, I unfortunately can't commit to any actual improvements at this time.
This is where you come in… I need your help to understand the need for improvements and make the case for improved SQL support. If you could take a few moments, please jot down your thoughts on the following:
You can post responses here, send me send email through the blog.
Hi Andrew, what are the wonderful new features that have been added to Access 2007/2010 which would get lost by using an SQL Server backend?
grovelli...I probably phrased that incorrectly whilst rushing this morning. Things like 'Attachment' fields, embeded macros, multi value fields and navigation forms (2010) etc are lost when using ADP's. All these little tweeks were surely put there to make life easier for us. It's just a shame they cannot be used in every situation.
('Wonderful new features' is probably a case of 'creative writing').
suggest to look at mdb (accdb) + linked tables to sql server - then you have all fearues of access. You only loose new field types and datamacros, which we already have as TSQL on sql server
Thanks for asking for Access needs/features. I've been using Access for many years (at least 10) and consider myself an advanced user. Access 2007 is my third version. Here is what I need from Access: 0) Make it crash less. 1) Make the help work again, especially the vba help. It worked great in Access 2003. Can't hardly get it to work in 2007. I have almost given up on Access for this reason alone. 2) Please make the user interface less clunky. 2003 worked even if it's feature set was less. I think the 2007 user interface stinks. I hate the ribbon. It's just hard to use. Just give me a good old fashioned pull down menu at the top, with optional pallets to choose context sensitive things from. 3) Make using Access as a front end to MySQL much, much better and faster. 4) Add more SQL features to make it create and drop tables etc. 5) Make the help work... please. 9) Make it faster. PLEEASE. Someone go through the code and find places to do the same thing in less time. Make it load faster. Make it load windows faster. Make it faster! While some things in 2007 work better, in my opinion, Access 2007 was the low spot in the Access family. It is slow, clunky, hard to use and believe me there are many days I would rather have Access 2003 back. Thanks for asking. -- Howard