Clever Geek Handbook

What are the main differences between Field and Field2 objects in Microsoft Access ..?

I am looking for some discussion of the differences between Field and Field2 objects in Microsoft Access. I am using Access 2007 as an interface to an IBM i-Series AS400 DB2 v6 SQL database.

There is such a link, which explicitly states that the field "Field2" is identical to "Field", but with additional available properties: https://msdn.microsoft.com/en-us/library/bb257445(v=office.12). aspx . But that doesn't describe in great detail the situations when they should be used.

There is also this which should state that DAO 12 is used to use 'Field2' and shows some code, but again that is not very much. However, it does show how it is used with Outlook and I am wondering if this is correct or if "Field (1)" will work as well: Accessing Field2 in Access 2007

So ... what are some reasons to use one over the other.? Additional properties are only used for new DB systems ..? Or some kind of software ..? Or what ..?

+3


source to share


1 answer


When using Access as the front-end to an ODBC data source, there should be no functional difference between objects DAO.Field

and DAO.Field2

. Objects Field2

have been extended to support access-specific structures such as fields Attachment

.



+4


source






More articles:


All Articles