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.

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.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"summerj" <(E-Mail Removed)> wrote in message
news:56D3D2FB-79C2-44D4-A757-(E-Mail Removed)...
>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.

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.

"Sylvain Lafontaine" wrote:

> 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.
>
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: sylvain aei ca (fill the blanks, no spam please)
>
>
> "summerj" <(E-Mail Removed)> wrote in message
> news:56D3D2FB-79C2-44D4-A757-(E-Mail Removed)...
> >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.
>
>
>