I’m using Access 2007 and was interested in its “Collect data through e-mail
messages” functionality. I reviewed the instructions on line
http://office.microsoft.com/en-us/ac...4271033.aspx#3
The one issue I’m having is with the following statement:
*******
If the table contains fields that support data collection, the wizard
starts. The first page of the wizard displays the major steps in the process.
If the destination table supports both the adding and the updating of data,
you perform six major steps in the wizard:
*******
When I run the wizard I get the first screen with 5 steps instead of 6.
Apparently my table does not support both adding and the updating of data.
How can I tell if the fields I wish to update support data collection?
How do I make my table support both the adding and the updating of data?

The strange thing is I can open the table and update records manually.
Thanks.

I found the answer to my question. The Table requires a Primary Key.
That was simple.


"h2fcell" wrote:

> I’m using Access 2007 and was interested in its “Collect data through e-mail
> messages” functionality. I reviewed the instructions on line
> http://office.microsoft.com/en-us/ac...4271033.aspx#3
> The one issue I’m having is with the following statement:
> *******
> If the table contains fields that support data collection, the wizard
> starts. The first page of the wizard displays the major steps in the process.
> If the destination table supports both the adding and the updating of data,
> you perform six major steps in the wizard:
> *******
> When I run the wizard I get the first screen with 5 steps instead of 6.
> Apparently my table does not support both adding and the updating of data.
> How can I tell if the fields I wish to update support data collection?
> How do I make my table support both the adding and the updating of data?
>
> The strange thing is I can open the table and update records manually.
> Thanks.

I have tested this feature with a small table, and it works like a charm. I
would like to test on a larger dataset using a query to narrow the email
list. I’d like to know what kind of query I need, to have the data updated
in the table the query is based on. I tied a select query, but the e-mail
reply did not successfully update the record. Do I need and update query?
Is there an example of Collect data through e-mail messages using a query
instead of a table?

"h2fcell" wrote:

> I found the answer to my question. The Table requires a Primary Key.
> That was simple.
>
>
> "h2fcell" wrote:
>
> > I’m using Access 2007 and was interested in its “Collect data through e-mail
> > messages” functionality. I reviewed the instructions on line
> > http://office.microsoft.com/en-us/ac...4271033.aspx#3
> > The one issue I’m having is with the following statement:
> > *******
> > If the table contains fields that support data collection, the wizard
> > starts. The first page of the wizard displays the major steps in the process.
> > If the destination table supports both the adding and the updating of data,
> > you perform six major steps in the wizard:
> > *******
> > When I run the wizard I get the first screen with 5 steps instead of 6.
> > Apparently my table does not support both adding and the updating of data.
> > How can I tell if the fields I wish to update support data collection?
> > How do I make my table support both the adding and the updating of data?
> >
> > The strange thing is I can open the table and update records manually.
> > Thanks.

OK looks like I’m the only one posting to this thread. Anyway after testing
this functionality I came to the conclusion that there is room for
improvement. One thing I would like is the capability to time stamp UPDATED
records. It would also be nice if we could email a graphical representation
of a form created in Access, to collect the data. Maybe Access 2010 will
improve the capability.

"h2fcell" wrote:

> I found the answer to my question. The Table requires a Primary Key.
> That was simple.
>
>
> "h2fcell" wrote:
>
> > I’m using Access 2007 and was interested in its “Collect data through e-mail
> > messages” functionality. I reviewed the instructions on line
> > http://office.microsoft.com/en-us/ac...4271033.aspx#3
> > The one issue I’m having is with the following statement:
> > *******
> > If the table contains fields that support data collection, the wizard
> > starts. The first page of the wizard displays the major steps in the process.
> > If the destination table supports both the adding and the updating of data,
> > you perform six major steps in the wizard:
> > *******
> > When I run the wizard I get the first screen with 5 steps instead of 6.
> > Apparently my table does not support both adding and the updating of data.
> > How can I tell if the fields I wish to update support data collection?
> > How do I make my table support both the adding and the updating of data?
> >
> > The strange thing is I can open the table and update records manually.
> > Thanks.