[AccessD] MSAccess XP to SQL2005 Backend

Robert/Arthur:

Thanks for the insights.  Upgrading Office would seem to be the logical
solution.  However, the cost of upgrading 1000 employees from XP to 2007
would be a bit high.  The cost of Mgmt Studio for me and a few others
would be easily justifiable.  Plus I get a new toy to learn and play
with.

Thanks again.

-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)

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert L.
Stewart
Sent: Thursday, January 03, 2008 8:44 AM
To: accessd at databaseadvisors.com
Cc: Steve Zayko
Subject: Re: [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)


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com