Join queries

[Guest]

Im not a programer but I have done a lot of work in Access MDB files. One of
the things that I have done in a mdb file that I can not seem to do in and
ADP file is to run Delete queries or update queries that contain joins in
them. Is there anyway to do this? I may be wrong but it seems to me that MDB
files are more user friendly than ADP files. Is there any benefit to using
an ADP over an Mdb and vice a versa

 

[Tom Ellison]

I believe you have posted this question again, more recently, and I believe
we will have that resolved.

As to benefits of ADP over MDB, there are a few. With reference to your
specific area of questions, the database engine is very different.

Jet is very limited for advanced work. SQL Server is capable of levels of
performance you cannot dream of having with Jet. This is a matter that is
often subjective. It depends on what you need done, and your ability to
exploit the vast advantages of SQL Server. It's not free. You have to work
at it.

Tom Ellison