I'm looking for some discussion of the differences between the 'Field' and 'Field2' objects in Microsoft Access. I'm using Access 2007 as a front-end to an IBM i-Series AS400 DB2 v6 SQL database.
There is this link, which plainly states the 'Field2' is identical to 'Field', but with additional properties available: https://msdn.microsoft.com/en-us/library/bb257445(v=office.12).aspx. But this doesn't really elaborate on the situations where it should be used.
Also there is this, which states DAO 12 must be referenced to use 'Field2', and shows some code, but again it doesn't elaborate much. It does however show how it's used with Outlook, and I wonder if that's correct or if if a 'Field(1)' would work also: Accessing Field2 in Access 2007
So...what are some reasons to use one over the other..? Are the additional properties only used for newer DB systems..? Or certain software..? Or what..?