Re: ADP or MBE


<quote>
The preferred way to connect to SQL Server is MDB file format or ACCDB file
format. This enables you to use the full flexibility of local tables and
local queries, while leveraging the full power of SQL Server. In addition,
MDB and ACCDB files link to multiple SQL Servers and a wide variety of other
data sources. Office Access 2007 contains many new features available in
both MDB and ACCDB file formats, but only a subset of those features are
available in ADPs.
</quote>

http://technet2.microsoft.com/Office/en-us/library/1dce641e-ba1c-446a-8ff2-221769a58ba51033.mspx?mfr=true

--
Brendan Reynolds
Access MVP

"CB" <CB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F87A33DE-0A52-4BE4-83F3-4A160A06B0CC@xxxxxxxxxxxxxxxx
What is the current concensus Access Project to SQL (ADP) or MBE Linked
Tables to SQL?

We are starting a new project and choosing. Which will be more supported?

Thanks,

vex


.

Relevant Pages

  • Re: The best file format to import/export data into sql database through asp.net application
    ... I see nothing wrong with MDB as asp.net has a data provider for it. ... We are developing a SQL server based asp.net application. ... be the most efficient format to import export relational data. ... Is there any better file format for import/export data? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Future of ADP - new article
    ... "Office Access 2007 offers two ways to connect to SQL Server data: ... to SQL Server is MDB file format or ACCDB file format. ... significantly faster in an ADP file. ...
    (microsoft.public.access.adp.sqlserver)
  • RE: Future of ADP - new article
    ... "Office Access 2007 offers two ways to connect to SQL Server data: ... to SQL Server is MDB file format or ACCDB file format. ... significantly faster in an ADP file. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Future of ADP - new article
    ... If you have both SSMS and ADP opening, you need to "refresh" in one to see the change made in the other. ... >> to SQL Server is MDB file format or ACCDB file format. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: From .mdb to .adp database
    ... I decided to go on with adp project, and i have created a store ... But queries are different stories. ... In SQL Server, there are Views, Stored Procedures, UDFs. ... Also, when you decide to use MDB front-end, you can choose use MDB ...
    (microsoft.public.access.adp.sqlserver)
Loading