Changes in Use of DISTINCTROW in Microsoft Access 2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;207761
SQL Server connections are a bit different, and we still have
unexplained speed differences in a Novell environment. Parameter
queries are a bit less forgiving of data type conversions, and
runtime errors which give a meaningful message in A97, and crash
A2K, sometimes give meaningless messages in A2K. In an MDB,
Msgbox refers to VBA.Msgbox which is slightly different to
the Access Msgbox you got in A97, and still get from an A2K2
MDE. Using err.raise, you must use explicit calls to MsgBox in
an MDE, because the default Access error handler will replace
err.Description. DAO initialisation at startup is different,
which may affect you if you are using WorkGroup security.
Jet security will affect you if the registry setting are applied.
Record-level locking can affect lock-unlock behaviour.
A2K2 is possibly even more susceptible to network flaws than
A97: your network should be fully patched before doing a corporate
-wide Access update.
Also, as documented elsewhere, no module-level workgroup
security, you can't share a database if you wish to add or
modify a form or report, and new features in general should
be avoided.
(david)
