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.
Tips
How-to
News
Videos
Stories
We have been getting a bunch of email from customers about using ADP’s with SQL Server 2008 and wanted to give everyone and update and some guidance.
Access 2007 ADP’s will run against SQL Server 2008 but do not support designing server objects (tables, views, stored procedures, functions and relationships).
SQL Server 2008 shipped after Office 2007 SP1 and after we had locked down all the fixes for Office 2007 SP2 (coming out in a few months).
If you rely on the design features of ADP’s we recommend;
Comments: (5) Collapse
Shipped?? Is there no holes in the walls between Office division and Developer division in Redmond???
Do you not have any responsibility to your partners and customers? Do you not talk with the people working with SQL Server?
What is going on, is it a war?
I agree. How is it that Access 2000 and SQL 2000 shipped and they didn't work together? How do you guys get away with this? Do you not communicate between departments?
Do you not have _ANYONE_ that knows anything about SQL Server? It's time to take ADP seriously-- I've heard that it's going to get a second breath of life in Access 14-- I'm just tired of making my ~100 clients upgrade every other year.
yah, for the record, it's NOT 4:06 pm either! nor is it 6pm!
I've been using a Beta version of Access SP2 12.0.6412.1000. I still get the same error warnings when I try to edit SQL2008 tables in an ADP project. Has your fixed been integrated into this version?
@Rickard @AKempf We do communicate with the SQL server folks and work to sync releases but at the end of the day shipping dates don't always line up. @AKempf we would like to hear more about how you use ADP's. Drop us a line at blogs.msdn.com/.../contact.aspx @Kevin Access 2007SP2 will not support editing SQL2008 server objects.
Comments: (loading) Collapse