Collect Data via Email won't provide existing information.

[Victoria@DIG]

What am I doing wrong?
Access 2007 sp1/Outlook 2007 sp1 (windows XP)

I have tried to use the Collect Data via email option. However, I've
noticed two things which I believe are related.
1) While going through the steps of the Collect Data wizard, I don't have
the screen that asks if I want to collect new data or update existing data.
2) When the end user (myself during testing) receives the initial request
email, none of the existing information is filled in.

I've tried initializing the wizard through the Collect Data ribbon button
and by right-clicking the table and selecting collect and update data.

This seems like a really cool addition to Access and I'd love it if I could
get it to work.

Thanks.

 

[Maurice]

Which option are you choosing? HTML should provide you with the options you
are looking for.

I tried to simulate your request as follows:

1. select table which contains information
2. Click Create email in [External Data] tab [Collect Data] group
3. Wizard starts - first page - > next
4. Follwing page (2) select HTML (other one needs infopath)
5. Following page (3) select new or update
6. You table should contain data to update in order to show something
7 etc...
8 etc...

I take it you take the same steps. Is ther any data in your tabel yet?

 

[Victoria@DIG]

Thanks Maurice. I tried it again, but no luck. THEN, I tried removing one
field that was an AutoNumber and voila, it worked! I guess I should have
read the Microsoft Help more closely.

Which option are you choosing? HTML should provide you with the options you
are looking for.

I tried to simulate your request as follows:

1. select table which contains information
2. Click Create email in [External Data] tab [Collect Data] group
3. Wizard starts - first page - > next
4. Follwing page (2) select HTML (other one needs infopath)
5. Following page (3) select new or update
6. You table should contain data to update in order to show something
7 etc...
8 etc...

I take it you take the same steps. Is ther any data in your tabel yet?
--
Maurice Ausum

What am I doing wrong?
Access 2007 sp1/Outlook 2007 sp1 (windows XP)

I have tried to use the Collect Data via email option. However, I've
noticed two things which I believe are related.
1) While going through the steps of the Collect Data wizard, I don't have
the screen that asks if I want to collect new data or update existing data.
2) When the end user (myself during testing) receives the initial request
email, none of the existing information is filled in.

I've tried initializing the wizard through the Collect Data ribbon button
and by right-clicking the table and selecting collect and update data.

This seems like a really cool addition to Access and I'd love it if I could
get it to work.

Thanks.