MDB or ADP, what's that all about?

[Jack Sheet]

When I try to navigate the Office Assistant in Access I frequently see two
references to "help" on a particular search topic. One link would have
"(MDB)" at the end, the ather ("ADP")

What's that all about, please? I religiously go down the "(MDB") route, for
no reason other than that the databases I create in Access have that
extension. Is that the right approach?

 

[Guest]

MDB are the native Access files. In other words, the traditional way.
ADP files are used when you have a SQL Server backend. In other words, your
application is an Access application but your data is in SQL Server. The
advantage of ADP is that it simplifies the process of stored procedures. In
ADP files you work with the stored procedures in SQL Server, as opposed to
queries in MDB files.

There are countless other differences but the main on is that ADP's work
with a SQL Server backend, and you use Access to create your tables and
stored procedures.

Ray

 

[Jack Sheet]

Thanks Ray

MDB are the native Access files. In other words, the traditional way.
ADP files are used when you have a SQL Server backend. In other words,
your
application is an Access application but your data is in SQL Server. The
advantage of ADP is that it simplifies the process of stored procedures.
In
ADP files you work with the stored procedures in SQL Server, as opposed to
queries in MDB files.

There are countless other differences but the main on is that ADP's work
with a SQL Server backend, and you use Access to create your tables and
stored procedures.

Ray