[AccessD] MSAccess XP to SQL2005 Backend

Steve,

Everything will work correctly. You cannot use Access to make
changes in the database any longer. You will have to use Management
Studio to do it from now on.

Robert

At 04:59 PM 1/2/2008, you wrote:
>Date: Wed, 2 Jan 2008 13:24:09 -0800
>From: "Steve Zayko" <szayko at secor.com>
>Subject: [AccessD] MSAccess XP to SQL2005 Backend
>To: "Access Developers discussion and problem solving"
>         <accessd at databaseadvisors.com>
>Message-ID:
>         <5D71EC0BA06F7C41B6088EF70CA4014E01AF591D at exchangecolo.secor.com>
>Content-Type: text/plain;       charset="us-ascii"
>
>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
>
>Stephen R. Zayko P.E.
>SECOR International Inc
>2321 Club Meridian Drive, Ste E.
>Okemos, MI 48864
>
>(517) 349-9499 (ph) ext 224
>(517) 204-5136 (cell)