.adp roadmap

[summerj]

I currently have an access data project accessing a SQL server 2000 database.
We are upgrading our 2000 databases to 2005. Will this cause any problems?

I have been reading the forum post and it looks like Microsoft is going away
from access data projects. Does anyone have a definite roadmap microsoft is
making? It is VERY hard to find out anything about this from Microsoft's web
sites.

 

[Sylvain Lafontaine]

You shouldn't have any problem connecting to a SQL-2005 database (in the
worst case scenario, put the database in the SQL-2000 compatibility mode)
but you won't be able to make any change to the design of the database using
the tools of Access if you are using a version of Access previous to 2007.

As to your second question, there is no known (public) roadmap for ADP: if
there was one, everyone would talk about it. Some people think that this
feature will be completely removed from a futur version of Access while
other (like me) think that it will be simply integrated into the now
standard ACCDB database format. (In other words, that the ACCDB format will
be upgraded to accommodate for the passthrough queries to be read/write
(instead of read only) and to be used as the record source for forms,
reports and controls). However, notice that both possibilities are pure
speculation.

 

[summerj]

Thank you. That is helpful. I just wish Microsoft would provide an official
direction on which direction they are taking so we can all plan ahead. I
would hope that they would integrate the features.