[Webinar] Streamline your web hosting managementRegister Today

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 350
  • Last Modified:

What are the benefits of ADP versus ACCB in Access 2007

What are the benefits of ADP versus ACCB in Access 2007, not counting the fact that you can directly modify linked SQL Server tables? I'm looking for what you consider the best online articles or your personal comments. I'm fairly fluent in Access, but am a beginner in SQL Server and ADP. TIA.
1 Solution
If you are starting from here then you should know that MS's current position is that ADPs are at the end of their road and no further development is planned.  Things are now focussed on the AccDb format and of course there are new features in Accdb which are not in either ADP or MDB formats.
I think MS expect you to be using ASP.net  or VB.net etc to frontend sql server.  Access is being pointed at Sharepoint rather than SQL server.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
That's really the only benefit, IMO. I'm not sold on the ACCDB format as yet, specifically the multivalued fields. I have no real problem with them, but rather with the inability to easily work with them via code. For my money, I'd rather use the .mdb/.accdb format and build my own connection to the server, and handle it that way.

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now