Ok, I didn't understand that you were after some integration assistance from the orginal post.
Have you looked at
Scribe software? It is relatively inexpensive and could do the job of creating a link in the Access db to the CRM record. If you don't want to purchase the integration tool, then you can have a look at the CRM SDK to see if you can find gain some insight. If you have already reviewed the SDK, then you may need to obtain the advise of a consultant who is familiar with Access in order to identify the best way to get the hyperlink (CRM Record URL into Access).
To construct the Quote URL, have a look at the construction of the URL in CRM by selecting Actions, Send Shortcut, look at the SDK or look at the construction in the Web browser Hyperlink address field. The construction, as you probably know, is something like this:
http://CRMURL/OrgName/sfa/quotes/edit.aspx?id={UniqueGuid}
The first part of the URL will always be the same. All you need to do is append the guid to the end of the string and update the Access database field.
Best Regards | Twitter: edwardsdna
