2007 Can't update existing information with email data collection

  • Thread starter Thread starter Chris Moore
  • Start date Start date
C

Chris Moore

I would like to use the new email data collection feature in Access 2007 to
update data in a table however I find that when I run the Email Data
Collection Wizard I am only presented with the option that allows for adding
new records to the table but not updating existing records as is documented
in the help file.

As a test I set up a new table with only and autonumber field and a text
field but Access still only offers the option to add new records. I then
removed the autonumber field - same issue. Is this feature not enabled or am
I doing something wrong? Thanks in advance for any help.
 
I would like to use the new email data collection feature in Access 2007 to
update data in a table however I find that when I run the Email Data
Collection Wizard I am only presented with the option that allows for adding
new records to the table but not updating existing records as is documented
in the help file.

As a test I set up a new table with only and autonumber field and a text
field but Access still only offers the option to add new records. I then
removed the autonumber field - same issue. Is this feature IS enabled or am
I doing something wrong? Thanks in advance for any help.
Click to expand...
 
AFAIK you cannot process these as updates only adds. Now if you want to
process them as updates you could store them in a special recieving table
and process the updates using a update query. To automate you could use a
timer event on a hidden form to run the update query but access would need
to be open. There are other options to include scheduler, lots of ideas on
how to do this are available. Search theses news groups for automating
backup and you'll get hundreds of options on how you could kick off the
update query.
 
Verify the server information is entered correctly in the Account Settings,
Click to expand...
and that your DNS settings in the Network pane of System Preferences are
correct.
 
Back
Top