Create an update mechanism

[abnewallo]

I have information in access tables that I would like to have external users
update. I was hoping to have a straight-forward mechanism where I can email
the users the information in a filled-in form, which they can change and
return, and the document can then be used to upload into the database.

I would like general idea of the possibilities, and I could work out the
details myself.

Thanks in advance

ABNEW

 

[Robert_DubYa]

The easiest way would probably do a query on the table and extract the
information you would like your recipient to view. Export the results to
excel by going to the
"tools" menu, pick "Office Links" and "Analyze with Excel". If you want the
person to review the complete table you can just click on the table and
export it the same way.

Have the person make the changes, save and send it back in Excel. Use an
update query to change the information in your table.

I would strongly recommend you back up your DB first incase you don't get it
right the first time (this is fairly easy) or if your recipient makes errors.

RW