Access 2003 SP? to work with SQL Server 2005 - microsoft.public.access

Message from discussion Access 2003 SP? to work with SQL Server 2005
Reply-To: "Craig Alexander Morrison" <c...@microsoft.newsgroups.public.com>
From: "Craig Alexander Morrison" <c...@microsoft.newsgroups.public.com>
References: <P4NAf.12$Xh3.2@fe06.lga>
Subject: Re: Access 2003 SP? to work with SQL Server 2005
Date: Sun, 22 Jan 2006 15:29:25 -0000
Lines: 39
Organization: Crawbridge Data (Scotland) Limited
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
Message-ID: <#M7zJn2HGHA.2212@TK2MSFTNGP15.phx.gbl>
Newsgroups: microsoft.public.access
NNTP-Posting-Host: 213.78.104.44
Path: g2news1.google.com!news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newshub.sdsu.edu!msrtrans!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl

No SQL Server 2005 will not support design changes from any version of 
Access now (and probably in the future).

ADPs are being sidelined if you have not yet invested heavily in this 
approach revert to using an MDB for the application.

If you have invested heavily then continue to develop using SQL Server 2000 
and then deploy on SQL Server 2005 (at compatibility level 8) if there is 
something that SQL Server 2005 gives you that SQL Server 2000 does not (the 
only thing I am aware of is that SQL Server 2005 Express is less restricted 
than SQL Server 2000 Desktop). If you are not using desktop or express then 
there is NOTHING -significant- that SQL Server 2005 gives you that SQL 
Server 2000 could not do, especially as Access 2003 cannot use anything that 
is new in SQL Server 2005.

Access 2003 can only connect to an exist SQL Server 2005 database, all 
design should be completed using SQLS tools.

I suggest you check out the newsgroup m.p.a.adp.sqlserver and in particular 
the posts of Mary Chipman of Microsoft on this matter.

-- 
Slainte

Craig Alexander Morrison
Crawbridge Data (Scotland) Limited


"Dean Slindee" <slin...@charter.net> wrote in message 
news:P4NAf.12$Xh3.2@fe06.lga...
> Is there a service pack for Office 2003 or Access 2003 that will allow 
> .adp projects to change table design when connected to a SQL Server 2005 
> database?
>
> Thanks,
> Dean S
>