Re: Access front end for sql server

On Sat, 28 Jun 2008 10:52:40 -0400, Gwindor <gwindor@xxxxxxxxxxx>
wrote:

No, you can also create an ODBC connection to the SQL Server and stay
within the familiar MDB environment.
It appears MSFT is phasing out support for ADP.

-Tom.


I have been doing programming in Access for about 10 years. I am now
being asked to make an Access front end for data that is stored in SQL
Server.

My impression is that the only way to do this is to use a .adp
application, rather than an .mdb file. Is that correct?

Is it possible to use DAO or ADO with .adp objects?

Also, is there a good manual on making access front ends for SQL
server data?

Gwindor
.

Relevant Pages

  • Re: Future of ADP - new article
    ... Start an Access2007 ADP, which connected to a SQL Serverdatabase. ... "Office Access 2007 offers two ways to connect to SQL Server data: ... to SQL Server is MDB file format or ACCDB file format. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Query Speed ... Access XP vs Access 2000
    ... With adp all SQL processing is done on the server. ...
    (microsoft.public.access.externaldata)
  • Re: .mdb, .adp and SQL Features and Benefits
    ... user's machine) that accesses one central MDB backend. ... So is an SQL BE for me, how would I do it, and what is an ADP? ... One should not move to Server back end for performance reasons. ...
    (comp.databases.ms-access)
  • Re: Why does SQL server 2005 not work with Access 2003 Projects (adps)?
    ... I alway use Access ADP as my tool for my SQL ... Server development. ... The copy/paste server objects with ADP is very handy. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: "I want MyMDB" (apologies to Mark Knopfler)
    ... The .adp does just what you are suggesting. ... .adp projects are MS Access front-ends that hook up to a MS SQL ... Server back-end. ... What I was suggesting is that the back-end should be a different SQL ...
    (comp.databases.ms-access)