Different Versions Have Different Capabilities

[Derek Hart]

I am using this query in Access 2003, and even though there are joins on
multiple tables, the only fields I make updateable only the fields in the
last "many" table, it does allow updating. However, I run this on a machine
with an earlier version of Access, and it does not. Should this be allowed
to work in both versions?

SELECT DISTINCTROW [FirstName] & " " & [LastName] AS FullName,
T_ClientPayments.Amount, T_ClientPayments.PaymentType,
T_ClientPayments.DateProcessed, T_ClientPayments.NumberPayment,
T_ClientPayments.Processed, T_ClientPayments.PaymentDate,
T_ClientPayments.Notes, T_Classes.ClassName, T_ClientClasses.SalesRep,
T_ClientPayments.ClientClassID, T_ClientPayments.ClientID,
T_Clients.LastName, T_Clients.FirstName, T_ClientPayments.MassUpdate
FROM T_Classes INNER JOIN (T_Clients INNER JOIN (T_ClientClasses INNER JOIN
T_ClientPayments ON T_ClientClasses.ClientClassID =
T_ClientPayments.ClientClassID) ON T_Clients.ClientID =
T_ClientClasses.ClientID) ON T_Classes.ClassID = T_ClientClasses.ClassID
WHERE (((T_ClientPayments.DateProcessed)>=BeginDateFilter() And
(T_ClientPayments.DateProcessed)<=EndDateFilter()))
ORDER BY T_ClientPayments.PaymentType;

 

[Allen Browne]

Access 2003 uses JET 4, the same query engine as Access 2000 and 2002.
Therefore if the same query in the same database works differently in A2003
than it does in A2002 or A2000, you probably want to check if those
computers need an update for JET 4.

For updates, go to:
http://support.microsoft.com/sp
and click on the link:
Microsoft Jet 4.0 Database Engine
You need at least SP4.

If the other database's tables/queries/relations are not the same, it may be
that the tables don't have a unique index on the ONE side of the joins, or
one of the other issues listed here:
http://allenbrowne.com/ser-61.html