Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Accessing SQL Server 2005 from Access 2003

Discussion in 'Information Technology' started by Howard, Jul 28, 2006.

  1. Howard

    Howard
    Expand Collapse
    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.
     
  2. Loading...

    Similar Threads Forum Date
    Microsoft Brings 64-Bit Perks in SQL Server 2000 Service Pack (Ziff Davis) Interfaith Dialogues May 7, 2005

  3. Alex Dybenko

    Alex Dybenko
    Expand Collapse
    Guest

    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

    "Howard" <Howard@discussions.microsoft.com> 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

    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.
     
  4. RoyVidar

    RoyVidar
    Expand Collapse
    Guest

    "Howard" <Howard@discussions.microsoft.com> wrote in message
    <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.


    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.

    --
    Roy-Vidar
     
  5. Norman Yuan

    Norman Yuan
    Expand Collapse
    Guest

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

    "Howard" <Howard@discussions.microsoft.com> 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
    > 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.
     

Share This Page