Accessing SQL Server 2005 from Access 2003

Hi,

My idea is to use Access 2003 as frontend and SQL Server 2005 as the
backend. I tried to dig out info on this, however, very hard. A lot of books
only mention MSDE on SQL7 or SQL2000.
The issues is when i tried to created a new table or view, the system
prompted me my design won't be saved. Currently, my Access 2003 is connected
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/14019-accessing-sql-server-2005-access-2003-a.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14019
to the SQL 2005. It seems i need to download some patches to solve this
issue, but what patch do i need ?

Howard.

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

AFAIK - there are no such patches, so for Access 2003 ADP you have to use
SQL Server 2000
But looks like that for MDB and linked table SQL Server 2005 works fine, i
did not really used it yet in live environment, but all my tests were passed

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14019
http://www.PointLtd.com

"Howard" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14019
news:CD54ED67-B99C-436E-B42A-C4ED36B3BF80@microsoft.com...
> Hi,
>
> My idea is to use Access 2003 as frontend and SQL Server 2005 as the
> backend. I tried to dig out info on this, however, very hard. A lot of
books
> only mention MSDE on SQL7 or SQL2000.
> The issues is when i tried to created a new table or view, the system
> prompted me my design won't be saved. Currently, my Access 2003 is
connected
> to the SQL 2005. It seems i need to download some patches to solve this
> issue, but what patch do i need ?
>
> Howard.

"Howard" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14019
:
> Hi,
>
> My idea is to use Access 2003 as frontend and SQL Server 2005 as the
> backend. I tried to dig out info on this, however, very hard. A lot
> of books only mention MSDE on SQL7 or SQL2000.
> The issues is when i tried to created a new table or view, the system
> prompted me my design won't be saved. Currently, my Access 2003 is
> connected to the SQL 2005. It seems i need to download some patches
> to solve this issue, but what patch do i need ?
>
> Howard.

I don't think there's going to be any patches, but check out the bottom
of http://support.microsoft.com/kb/913089/
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14019

There's a free utility you can use. There are also third party tools.

--
Roy-Vidar

You will buy the "patch" sometime next year, which is Access2007, if you
want to create SQL Server2005 objects(table, view...) with ADP.

"Howard" wrote in message
news:CD54ED67-B99C-436E-B42A-C4ED36B3BF80@microsoft.com...
> Hi,
>
> My idea is to use Access 2003 as frontend and SQL Server 2005 as the
> backend. I tried to dig out info on this, however, very hard. A lot of
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14019
> books
> only mention MSDE on SQL7 or SQL2000.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14019
> The issues is when i tried to created a new table or view, the system
> prompted me my design won't be saved. Currently, my Access 2003 is
> connected
> to the SQL 2005. It seems i need to download some patches to solve this
> issue, but what patch do i need ?
>
> Howard.