Append Only Memo Field

[Proposal Doctor]

I am interested in using an Append Only Field in my applications and a
statement in T. Hennig et.al.'s "Access 2007 VBA" has me confused.

It says, "This, however, requires that Access is installed to retrieve this
information." The information that the statement refers to is the
ColumnHistory information (page 187).

My question is, How do I know if Access 2007 was installed with
ColumnHistory compatibility?


In Field Properties on my PC there is a row to set the Append Only value
(Yes/No). Is this where I check for compatibility on every user's PC? Can
Access 2007 be installed without the Append Only Field with either the full
version or the runtime?

Thanks.

David

 

[GM Leonric]

I am interested in using an Append Only Field in my applications and a
statement in T. Hennig et.al.'s "Access 2007 VBA" has me confused.  

It says, "This, however, requires that Access is installed to retrieve this
information."  The information that the statement refers to is the
ColumnHistory information (page 187).

My question is, How do I know if Access 2007 was installed with
ColumnHistory compatibility?  

In Field Properties on my PC there is a row to set the Append Only value
(Yes/No).  Is this where I check for compatibility on every user's PC?  Can
Access 2007 be installed without the Append Only Field with either the full
version or the runtime?

Thanks.

David  

The default setting for Memo fields is for the Append Only option to
be turned off, so you'd have to turn it on for each field in your
database in order to have the history accessible to the users.

I believe what the quote refers to is that the user must have Access
2007 installed in order to be able to get at the Column History using
the right click option on the field. If the user is running using the
RunTime, they will not be able to get the column history. If they have
Access 2007 installed they will. You can get around the runtime
restriction by using VBA code to access the Column History data. The
method for doing this is Application.ColumnHistory("Table1", "Field1",
"[ID]=1") where Table1 is the table name, Field1 is the field name you
want the history on, and [ID]=2 is some where clause to determine
which records you want the history of (in this case the record where
the ID field is equal to 1. It returns the history as a string, so you
can output it with a message box or store it in a string variable.

Keven Denen

 

[Proposal Doctor]

Thanks Keven,

That was the exact response that I needed!

David

I am interested in using an Append Only Field in my applications and a
statement in T. Hennig et.al.'s "Access 2007 VBA" has me confused.

It says, "This, however, requires that Access is installed to retrieve this
information." The information that the statement refers to is the
ColumnHistory information (page 187).

My question is, How do I know if Access 2007 was installed with
ColumnHistory compatibility?

In Field Properties on my PC there is a row to set the Append Only value
(Yes/No). Is this where I check for compatibility on every user's PC? Can
Access 2007 be installed without the Append Only Field with either the full
version or the runtime?

Thanks.

David

The default setting for Memo fields is for the Append Only option to
be turned off, so you'd have to turn it on for each field in your
database in order to have the history accessible to the users.

I believe what the quote refers to is that the user must have Access
2007 installed in order to be able to get at the Column History using
the right click option on the field. If the user is running using the
RunTime, they will not be able to get the column history. If they have
Access 2007 installed they will. You can get around the runtime
restriction by using VBA code to access the Column History data. The
method for doing this is Application.ColumnHistory("Table1", "Field1",
"[ID]=1") where Table1 is the table name, Field1 is the field name you
want the history on, and [ID]=2 is some where clause to determine
which records you want the history of (in this case the record where
the ID field is equal to 1. It returns the history as a string, so you
can output it with a message box or store it in a string variable.

Keven Denen