Accessing SQL Server 2005 from Access 2003

[Guest]

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.

 

[Alex Dybenko]

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
http://www.PointLtd.com

 

[RoyVidar]

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/

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

 

[Norman Yuan]

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