[AccessD] MSAccess XP to SQL2005 Backend

There is no easy solution that a service pack could fix, because SQL 2005
differs significantly in its architecture. What will work, I think, is
upgrading the Access app to Access 2007.

Arthur

On 1/2/08, Steve Zayko <szayko at secor.com> wrote:
>
> I have been using an MSAccess adp project FE that connects to a SQL2000
> BE database for about 3 years now.  The administrative powers that be
> will be upgrading the SQL 2000 server to SQL 2005 next month.  I did a
> test upgrade and got the following error message:
>
> You have connected to a version of SQL Server later than SQL Server
> 2000.  The version of Access that you are using was released before the
> version of SQL Server to which you are connected.  For this reason, you
> might encounter problems.
>
> The problem I am having is that all tables and queries are not
> visible/accessible/usable.
>
> Does anyone know of a service pack or patch that would give me an easy
> solution?
>
> Thanks
>
> -Z
>