Access 2010 ADP or MDB

Posted on 2010-03-23
Medium Priority
Last Modified: 2013-12-05
Hi All,

Anyone got any official notes/guidance to say wether using an Access SQL Project (ADP) is recommended for Access 2010 when using an SQL backend?

I've got an Access 2007 ADP project and I'm wondering if I should convert to an MDB or continue with ADP.

Question by:jmsjms
  • 3
  • 2
  • 2
LVL 86
ID: 28340819
ADPs are still supported as of 2010, in the same manner as they were in 2007. If you have a working ADP I see no valid reason to change to linked tables. Note that support for ADPs is limited in newer versions of SQL Server (2005 and 2008). The limitations are in the design areas, which you can get around by using SSMS, but to me that doesn't bode well for ADPs.

See the posts from Mary Chipman of Microsoft here, but please ignore the rantings of Aaron Kempf, who is a scourge on the Access newsgroups:
LVL 40

Expert Comment

by:Vadim Rapp
ID: 28465112
Depends on what you want to do with this ADP. If you expect significant further development, then maybe it will make sense indeed to convert to MDB, or even to Visual Studio. If just use it, then of course, why bother. (But then why would you mention 2010).

Author Comment

ID: 28465872
THe database isnt static.  We continually modify it and we will be getting Office 2010 at some stage.  Hence my question about wether to carry on with an ADP or move to MDB.

I've just seen so much unsubstantiated stuff on the net about MS ditching ADP...

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

LVL 40

Expert Comment

by:Vadim Rapp
ID: 28475471
I'm pretty sure the unsubstantiated stuff was actually originating from MS itself, depending on the direction of the political winds there in every particular moment.
LVL 86

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1000 total points
ID: 28543506
Still, I see no reason to move to move to .mdb if you have a working file. There are significant changes in 2010, but none that would affect an existing ADP or MDB app, or that would affect any changes you may wish to make.

If you are embarking on a NEW project, then the prevailing winds seem to say to use the .mdb/.accdb format with linked tables.

IIRC, according to MS the number of people using the .adp format is very, very small. MS would, of course, like to put their money into the right channel, and will focus their energies on the areas most widely used. In other words, while you probably won't see support for ADPs removed you also won't see much going toward implementation of new ADP related features (like design support for newer versions of SQL, for example, or direct integration with new SQL features, etc etc).

LVL 40

Assisted Solution

by:Vadim Rapp
Vadim Rapp earned 1000 total points
ID: 28548742
> changes in 2010, but none that would affect an existing ADP or MDB app,

This very area on EE is the evidence that at least in 2007, there were lots of things that affected an existing ADP. And, remarkably, all affected in the same direction. "My adp worked in A03, why this does not work in 07". "Why in 07 this became 100 times slower". "Why filter button became disabled" (the most recent one I remember).

I guess, product with _that_ toolbar* simply can't not to ruin an application.

*) or, more seriously, with _that_ attention paid to the toolbar by the developers

Author Closing Comment

ID: 31705972
Thanks for your input Experts.  I'm going to carry on with the App in ADP but when time permits move back to MDB or consider using dotNet.

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question