Re: A2007 ADPs

"Guy" <Guy@xxxxxxxxxx> wrote in
news:e4fIbXBrHHA.4624@xxxxxxxxxxxxxxxxxxxx:

1) Microsoft have introduced a new database format . accdb, does
this mean they are now going to support, or are prepared to
support, 3 different formats all with slightly different features?

Er, what are you talking about? ACCDB is a new version of Jet. It
could have been called Jet 5 and used the MDB format, but the Access
team probably wants to shed the undeserved bad reputation of Jet
(since it's ignorant people that think Jet is bad, this silly name
change may fool them).

An MDB is a Jet database.

An ACCDB is a Jet database.

Both can be used for storing the objects for an application that
connects to any back end.

So, in one sense, it's not really a third format, it's just a
variation of the old Jet format.

On the other hand, if you consider that all versions of Access back
to A2K are supported, you have *four* different formats for
MDB/ACCDB.

But I don't think that way of looking at it makes much sense.

2) The ADP interface does not appear to have been significantly
improved since inception.

Bugs have been fixed and regressed in various incarnations of the
ADP, according to reports from those who were trying desperately to
make use of ADPs.

3) Many of the new features available in A2007 don't appear to be
supported in ADPs.

Just as they aren't supported in MDBs, because they are
ACCDB-specific features. That is, things like multi-value fields are
a db engine feature, not a front-end feature.

4) Commentary suggestes that linked tables are now the preferred
option to talking to non .MDB databases.

That is what MS is saying, and their reason is because there are
just as many inefficient layers between an ADP and SQL Server as
between an MDB and SQL Server.

Can only mean one thing the end of the ADP format, and unless I
hear anything to contary this is what I will be advising my
employer.

I would say that if you have existing ADP apps, keep maintaining
them as ADPs, but do all development as ACCDB/MDB to ODBC.

Thankfully I am currently working towards .NET MCPD (Web
Developer) certification paid for by the company, although, having
said that the amount of (almost) irrelavant information you have
to learn about classes you will probably/may never use for your
70-528 exam is astounding, when I would suggest that a large
majority of the worlds computer applications just talk to
directly/indirectly to an RDBMS database via a form (web based or
otherwise) and most are not writing the next replacement for
Excel. Still, no different from Computer Science at University I
suppose (and not for this newsgroup forum).

The whole point of .NET, seems to me, is stateless data editing,
which is not really what Access apps are about, so I just don't see
how .NET can ever fit into the niche filled by Access apps.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.

Relevant Pages

  • Re: Form created in word 2007 to be open in word 2003
    ... WinWord group your fundamental problem is that the older format doesn't ... support the features of 2007 you're using in your document. ... I want to create this form in word 2007 using activex controls and they seem ...
    (microsoft.public.mac.office.word)
  • Re: charts and smart art graphics choices grayed out in gallery
    ... time you work with a file saved in the 97-2004 format. ... support those features so they're disabled in those documents. ... format the effects will be saved as pictures and un-editable in earlier ...
    (microsoft.public.mac.office.word)
  • Re: Warning when saving XML Spreadsheet 2003 with Excel 2007
    ... I made sure I was saving my data in a format that ... save the file it pops up a warning dialog saying that some features may ... Spreadsheet doesn't support so is there any way to disable the warning? ...
    (microsoft.public.excel)
  • NewestShareware.com Issue #120
    ... An easier to read version of this newsletter in HTML format can ... Program Name - Supported Platforms - Type - Category ... Download file size: 3518 K ... Full Windows Vista Support ...
    (comp.software.shareware.announce)
  • NewestShareware.com Issue #148
    ... An easier to read version of this newsletter in HTML format can ... Program Homepage/Download url ... Support Converting local HTML, MHT, TXT files to image; ... left behind from software installations. ...
    (comp.software.shareware.announce)