Welcome to SPN

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

Sign Up Now!

Access 2007 Front End for SQL 2005

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

  1. Brakerm19

    Brakerm19
    Expand Collapse
    Guest

    How can Access 2007 be used as a Front End for an SQL 2005 Database. Access
    2003 and older has the options of create new project which created an .adp
    file. This Access .adp file could create a new database, change existing
    data, change the design of an existing sql 2000 database. Access 2003 could
    not change the design of SQL 2005 DB.

    Is there a comparable feature in Access 2007 where new databases can be
    added to an SQL 2005 instance, or change data and design of an existing
    database in an instance of SQL 2005?
     
  2. Loading...


  3. Kip

    Kip
    Expand Collapse
    Guest

    when creating a new database, click the folder icon next to the filename. it
    gives you options of where to save the database, and what type of database to
    create. select access project. I think it will allow you to change the design
    of the database, but I haven't tried it. let me know if it works.

    "Brakerm19" wrote:

    > How can Access 2007 be used as a Front End for an SQL 2005 Database. Access
    > 2003 and older has the options of create new project which created an .adp
    > file. This Access .adp file could create a new database, change existing
    > data, change the design of an existing sql 2000 database. Access 2003 could
    > not change the design of SQL 2005 DB.
    >
    > Is there a comparable feature in Access 2007 where new databases can be
    > added to an SQL 2005 instance, or change data and design of an existing
    > database in an instance of SQL 2005?
     
  4. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    "Brakerm19" <Brakerm19@discussions.microsoft.com> wrote in message
    news:9B107748-5869-4745-8F00-2252FD2749AC@microsoft.com...
    > How can Access 2007 be used as a Front End for an SQL 2005 Database.
    > Access
    > 2003 and older has the options of create new project which created an .adp
    > file. This Access .adp file could create a new database, change existing
    > data, change the design of an existing sql 2000 database. Access 2003
    > could
    > not change the design of SQL 2005 DB.
    >
    > Is there a comparable feature in Access 2007 where new databases can be
    > added to an SQL 2005 instance, or change data and design of an existing
    > database in an instance of SQL 2005?


    Here's what Clint Covington, Lead Product Manager, blogged about the
    deprecation of ADP in Access 2007:

    http://www.utteraccess.com/forums/showthreaded.php?Cat=&Number=1057772&page=&view=&sb=5&o=&vc=1

    The recommendation is use Access, Access database engine (the successor to
    Jet), and ODBC to link SQL Server Tables. As to modifying an SQL Server
    database, SQL Server has some excellent tools. (Most shops with which I am
    familiar have DBAs who don't want anyone else mucking about in their SQL {or
    other brand} Server definitions, anyway.)

    Larry Linson
    Microsoft Access MVP
     
  5. Albert D.Kallal

    Albert D.Kallal
    Expand Collapse
    Guest

  6. RoyVidar

    RoyVidar
    Expand Collapse
    Guest

    Albert D.Kallal wrote in message
    <#xqZYdEiGHA.3496@TK2MSFTNGP02.phx.gbl> :
    > Just to clear things up here:
    >
    > a2007 will have full support for ADP projects, and that means sql
    > 2005 databases....


    Full support - that sounds interesting!

    It sounds much better than what one would expect after reading this
    http://support.microsoft.com/kb/917418/en-us
    "However, future Access product releases may offer limited support for
    using graphical design tools when connected to a SQL Server 2005
    database"

    --
    Roy-Vidar
     
  7. RoyVidar

    RoyVidar
    Expand Collapse
    Guest

    Larry Linson wrote in message <OdwIvWEiGHA.4040@TK2MSFTNGP05.phx.gbl> :
    > "Brakerm19" <Brakerm19@discussions.microsoft.com> wrote in message
    > news:9B107748-5869-4745-8F00-2252FD2749AC@microsoft.com...
    >> How can Access 2007 be used as a Front End for an SQL 2005
    >> Database. Access
    >> 2003 and older has the options of create new project which created
    >> an .adp
    >> file. This Access .adp file could create a new database, change
    >> existing
    >> data, change the design of an existing sql 2000 database. Access
    >> 2003 could
    >> not change the design of SQL 2005 DB.
    >>
    >> Is there a comparable feature in Access 2007 where new databases
    >> can be
    >> added to an SQL 2005 instance, or change data and design of an
    >> existing
    >> database in an instance of SQL 2005?

    >
    > Here's what Clint Covington, Lead Product Manager, blogged about the
    > deprecation of ADP in Access 2007:
    >
    > http://www.utteraccess.com/forums/showthreaded.php?Cat=&Number=1057772&page=&view=&sb=5&o=&vc=1
    >
    > The recommendation is use Access, Access database engine (the
    > successor to Jet), and ODBC to link SQL Server Tables. As to
    > modifying an SQL Server database, SQL Server has some excellent
    > tools. (Most shops with which I am familiar have DBAs who don't want
    > anyone else mucking about in their SQL {or other brand} Server
    > definitions, anyway.)
    >
    > Larry Linson
    > Microsoft Access MVP


    Are you by any chance mixing up "Data Access Pages" (DAP) and "Access
    Data Projects" (ADP) here?

    --
    Roy-Vidar
     
  8. Albert D.Kallal

    Albert D.Kallal
    Expand Collapse
    Guest

  9. Brakerm19

    Brakerm19
    Expand Collapse
    Guest

    this is exactly what i was looking for.

    thank you for the information

    brakerm19

    "Kip" wrote:

    > when creating a new database, click the folder icon next to the filename. it
    > gives you options of where to save the database, and what type of database to
    > create. select access project. I think it will allow you to change the design
    > of the database, but I haven't tried it. let me know if it works.
    >
    > "Brakerm19" wrote:
    >
    > > How can Access 2007 be used as a Front End for an SQL 2005 Database. Access
    > > 2003 and older has the options of create new project which created an .adp
    > > file. This Access .adp file could create a new database, change existing
    > > data, change the design of an existing sql 2000 database. Access 2003 could
    > > not change the design of SQL 2005 DB.
    > >
    > > Is there a comparable feature in Access 2007 where new databases can be
    > > added to an SQL 2005 instance, or change data and design of an existing
    > > database in an instance of SQL 2005?
     
  10. Manuel Lopez

    Manuel Lopez
    Expand Collapse
    Guest

    There may have been some confusion about DAP vs ADP, but as I understand it
    they are definitely moving away from ADPs. In Access 2007, there is no
    option (I can easily find) to create a new access project (adp), as there is
    for a mdb (now an accdb), and the recommendation is to use accdb for all new
    Access frontends.
    See the discussion at:
    http://www.databaseadvisors.com/gazette/sqlexpress.htm

    Mary Chipman: "FWIW, the Access team has moved away from recommending ADPs
    as a front-end to SQLS apps over the last year or so, based on several
    public talks given by team members at industry conferences. If you are
    contemplating new development with Access as a FE to a SQLS BE, you'll
    likely be ahead of the game with an efficiently-designed MDB/linked table
    solution rather than an ADP."


    > Are you by any chance mixing up "Data Access Pages" (DAP) and "Access
    > Data Projects" (ADP) here?
    >
    > --
    > Roy-Vidar
    >
    >
     
  11. Robert Morley

    Robert Morley
    Expand Collapse
    Guest

    I was kinda hoping that MS would change directions here, cuz this really
    sucks. Not that long ago, they were encouraging EVERYONE to migrate to
    ADP's with either MSDE or SQL Server as the back end...so when our Access
    project at work outgrew Access alone, I dutifully migrated to ADP as the FE
    with a SS2K BE. Now, they've decided that maybe it's "too hard" <whine
    whine> to have everyone do what MS told us to, and so they'll just go back
    to plan A.

    So now it would seem that at some point in the future (when our organization
    can be bothered to actually migrate past 4- to 6-year-old technology), I'm
    going to wind up migrating absolutely everything BACK to an MDB with a
    somewhat more traditional FE/BE structure (one that doesn't readily support
    cataloguing and opening server-side views in the FE). Somehow, I'm sure I'm
    not alone in having taken this development path.

    If MS is going to "firmly encourage" people to follow a certain technology
    path, it would behove them to firmly follow it themselves, and not flip-flop
    every time the going gets rough.


    Rob

    "Manuel Lopez" <limited@newsgroups.nospam> wrote in message
    news:%23rdwf7XjGHA.5020@TK2MSFTNGP02.phx.gbl...
    > There may have been some confusion about DAP vs ADP, but as I understand
    > it they are definitely moving away from ADPs. In Access 2007, there is no
    > option (I can easily find) to create a new access project (adp), as there
    > is for a mdb (now an accdb), and the recommendation is to use accdb for
    > all new Access frontends.
    > See the discussion at:
    > http://www.databaseadvisors.com/gazette/sqlexpress.htm
    >
    > Mary Chipman: "FWIW, the Access team has moved away from recommending
    > ADPs as a front-end to SQLS apps over the last year or so, based on
    > several public talks given by team members at industry conferences. If you
    > are contemplating new development with Access as a FE to a SQLS BE, you'll
    > likely be ahead of the game with an efficiently-designed MDB/linked table
    > solution rather than an ADP."
     
  12. Sylvain Lafontaine

    Sylvain Lafontaine
    Expand Collapse
    Guest

    What happens if you try to open an existing ADP project?

    --
    Sylvain Lafontaine, ing.
    MVP - Technologies Virtual-PC
    E-mail: http://cerbermail.com/?QugbLEWINF


    "Manuel Lopez" <limited@newsgroups.nospam> wrote in message
    news:%23rdwf7XjGHA.5020@TK2MSFTNGP02.phx.gbl...
    > There may have been some confusion about DAP vs ADP, but as I understand
    > it they are definitely moving away from ADPs. In Access 2007, there is no
    > option (I can easily find) to create a new access project (adp), as there
    > is for a mdb (now an accdb), and the recommendation is to use accdb for
    > all new Access frontends.
    > See the discussion at:
    > http://www.databaseadvisors.com/gazette/sqlexpress.htm
    >
    > Mary Chipman: "FWIW, the Access team has moved away from recommending
    > ADPs as a front-end to SQLS apps over the last year or so, based on
    > several public talks given by team members at industry conferences. If you
    > are contemplating new development with Access as a FE to a SQLS BE, you'll
    > likely be ahead of the game with an efficiently-designed MDB/linked table
    > solution rather than an ADP."
    >
    >
    >> Are you by any chance mixing up "Data Access Pages" (DAP) and "Access
    >> Data Projects" (ADP) here?
    >>
    >> --
    >> Roy-Vidar
    >>
    >>

    >
    >
     
  13. Manuel Lopez

    Manuel Lopez
    Expand Collapse
    Guest

    They're fairly good about backward compatibility (dao still works! and
    existing .adp projects should work), but there was some instability and
    uncertainty in laying down a new direction (nothing human is lasting etc.).
    Things become clear at different times, and there are trade-offs to
    continuing to support past plans, though they can be faulted for not
    sufficiently anticipating or testing out the pitfalls in various plans. At
    any rate, they're a lot of good changes in ACC2007 (such as Excel-like
    presentation and editing of tables), and sql server 2005 has a much better
    interface and programmability than 2k. It's true they still end up with
    different interfaces, a client-side Access and a server-side Sql Server.


    "Robert Morley" <rmorley@magma.ca.N0.Freak1n.sparn> wrote in message
    news:eWKZeqYjGHA.4040@TK2MSFTNGP05.phx.gbl...
    >I was kinda hoping that MS would change directions here, cuz this really
    >sucks. Not that long ago, they were encouraging EVERYONE to migrate to
    >ADP's with either MSDE or SQL Server as the back end...so when our Access
    >project at work outgrew Access alone, I dutifully migrated to ADP as the FE
    >with a SS2K BE. Now, they've decided that maybe it's "too hard" <whine
    >whine> to have everyone do what MS told us to, and so they'll just go back
    >to plan A.
    >
    > So now it would seem that at some point in the future (when our
    > organization can be bothered to actually migrate past 4- to 6-year-old
    > technology), I'm going to wind up migrating absolutely everything BACK to
    > an MDB with a somewhat more traditional FE/BE structure (one that doesn't
    > readily support cataloguing and opening server-side views in the FE).
    > Somehow, I'm sure I'm not alone in having taken this development path.
    >
    > If MS is going to "firmly encourage" people to follow a certain technology
    > path, it would behove them to firmly follow it themselves, and not
    > flip-flop every time the going gets rough.
    >
    >
    > Rob
    >
    > "Manuel Lopez" <limited@newsgroups.nospam> wrote in message
    > news:%23rdwf7XjGHA.5020@TK2MSFTNGP02.phx.gbl...
    >> There may have been some confusion about DAP vs ADP, but as I understand
    >> it they are definitely moving away from ADPs. In Access 2007, there is
    >> no option (I can easily find) to create a new access project (adp), as
    >> there is for a mdb (now an accdb), and the recommendation is to use accdb
    >> for all new Access frontends.
    >> See the discussion at:
    >> http://www.databaseadvisors.com/gazette/sqlexpress.htm
    >>
    >> Mary Chipman: "FWIW, the Access team has moved away from recommending
    >> ADPs as a front-end to SQLS apps over the last year or so, based on
    >> several public talks given by team members at industry conferences. If
    >> you are contemplating new development with Access as a FE to a SQLS BE,
    >> you'll likely be ahead of the game with an efficiently-designed
    >> MDB/linked table solution rather than an ADP."

    >
    >
     
  14. Brendan Reynolds

    Brendan Reynolds
    Expand Collapse
    Guest

    This is one of those 'picture paints a thousand words' situations, so here's
    a link to a picture ...

    http://brenreyn.brinkster.net/newadp.jpg

    I agree that an MDB or ACCDB is probably a better choice for new apps, but
    for the time being at least ADPs are still supported.

    --
    Brendan Reynolds
    Access MVP

    "Manuel Lopez" <limited@newsgroups.nospam> wrote in message
    news:%23rdwf7XjGHA.5020@TK2MSFTNGP02.phx.gbl...
    > There may have been some confusion about DAP vs ADP, but as I understand
    > it they are definitely moving away from ADPs. In Access 2007, there is no
    > option (I can easily find) to create a new access project (adp), as there
    > is for a mdb (now an accdb), and the recommendation is to use accdb for
    > all new Access frontends.
    > See the discussion at:
    > http://www.databaseadvisors.com/gazette/sqlexpress.htm
    >
    > Mary Chipman: "FWIW, the Access team has moved away from recommending
    > ADPs as a front-end to SQLS apps over the last year or so, based on
    > several public talks given by team members at industry conferences. If you
    > are contemplating new development with Access as a FE to a SQLS BE, you'll
    > likely be ahead of the game with an efficiently-designed MDB/linked table
    > solution rather than an ADP."
    >
    >
    >> Are you by any chance mixing up "Data Access Pages" (DAP) and "Access
    >> Data Projects" (ADP) here?
    >>
    >> --
    >> Roy-Vidar
    >>
    >>

    >
    >
     
  15. Robert Morley

    Robert Morley
    Expand Collapse
    Guest

    Hehehe, thanks Brendan.


    Rob

    "Brendan Reynolds" <brenreyn@discussions.microsoft.com> wrote in message
    news:OZqeqahjGHA.5036@TK2MSFTNGP04.phx.gbl...
    >
    > This is one of those 'picture paints a thousand words' situations, so
    > here's a link to a picture ...
    >
    > http://brenreyn.brinkster.net/newadp.jpg
    >
    > I agree that an MDB or ACCDB is probably a better choice for new apps, but
    > for the time being at least ADPs are still supported.
    >
    > --
    > Brendan Reynolds
    > Access MVP
     
  16. aaron.kempf@gmail.com

    aaron.kempf@gmail.com
    Expand Collapse
    Guest

    hey screw you don't spread lies about ADP


    what they are moving away from is MDB





    Manuel Lopez wrote:
    > There may have been some confusion about DAP vs ADP, but as I understand it
    > they are definitely moving away from ADPs. In Access 2007, there is no
    > option (I can easily find) to create a new access project (adp), as there is
    > for a mdb (now an accdb), and the recommendation is to use accdb for all new
    > Access frontends.
    > See the discussion at:
    > http://www.databaseadvisors.com/gazette/sqlexpress.htm
    >
    > Mary Chipman: "FWIW, the Access team has moved away from recommending ADPs
    > as a front-end to SQLS apps over the last year or so, based on several
    > public talks given by team members at industry conferences. If you are
    > contemplating new development with Access as a FE to a SQLS BE, you'll
    > likely be ahead of the game with an efficiently-designed MDB/linked table
    > solution rather than an ADP."
    >
    >
    > > Are you by any chance mixing up "Data Access Pages" (DAP) and "Access
    > > Data Projects" (ADP) here?
    > >
    > > --
    > > Roy-Vidar
    > >
    > >
     
  17. aaron.kempf@gmail.com

    aaron.kempf@gmail.com
    Expand Collapse
    Guest

    Robert;

    I fully hear your pain.

    ADP is a fully superior platform to MDB in every concievable fashion.





    Robert Morley wrote:
    > Hehehe, thanks Brendan.
    >
    >
    > Rob
    >
    > "Brendan Reynolds" <brenreyn@discussions.microsoft.com> wrote in message
    > news:OZqeqahjGHA.5036@TK2MSFTNGP04.phx.gbl...
    > >
    > > This is one of those 'picture paints a thousand words' situations, so
    > > here's a link to a picture ...
    > >
    > > http://brenreyn.brinkster.net/newadp.jpg
    > >
    > > I agree that an MDB or ACCDB is probably a better choice for new apps, but
    > > for the time being at least ADPs are still supported.
    > >
    > > --
    > > Brendan Reynolds
    > > Access MVP
     

Share This Page