[AccessD] Access ADP file format

Arthur Fuller fuller.artful at gmail.com
Fri Mar 24 06:34:36 CDT 2023


Does anyone know why the Access team decided to kill that file format? I
personally loved it. and wish it were still alive. Perhaps someone higher
up on the food chain realized how good it was, and how bad it made SSMS
look at the time, at threw a hissy fit.

I know that at least one or two of you MVP types have insider access to
these discussions. Care to shed some light on this particular decision?

I recall asking another question similar to this, about why Access limits
the number of relationship diagrams to 1. Turns out I can live with that: I
have found an elegant work-around. Only recently did I realize that an
Access FE can link to any number of BEs, so I have adopted the strategy of
Schemas from SQL Server. The BE I'm working on currently has a half-dozen
BEs, each corresponding to a group of tables within the overall domain.
This works splendidly, and enables me to concentrate on a particular area
of interest without having to wade through irrelevant clutter. I don't know
about you, but when the database has ~100 tables, a single relationship
diagram is incomprehensible.

I digress. Why did the Access team abandon the ADP file format?

-- 
Arthur


More information about the AccessD mailing list