Generate Outlook e-mail links to Open an Access 2010 DB Form, using Sharepoint 2010

[BuildIT]

Hi All,

I designed an Access DB which enables to record communications between users. It sends e-mails and users are responding to these e-mails by login in an mde file.

What would be a significant improvement for us is to have a link generated from Access inside the sent e-mails which would directly open the correct form to respond with the desired record displayed.

I have seen an example posted in the forum with Sharepoint 2010 which seems to be a good choice because we have it.


I am new with Sharepoint so:
Do I have to use a Sharepoint Site? If yes can I use an existing one?
Do I have to switch to an accdb from a mdb?
What are the Steps I have to follow in Sharepoint?

Thank you for your time.

[zmbd]

If you are only doing data entry:
Create a new front-end file with minimal links, forms and code, set the form to open in dataentry mode.

In the database in the options set this form to open when the file opens.

Send a hyperlink to your file in the email.

This may be the simplest method.

-
If you wish to use sharepoint, then you will need to potentially redesign your database; however, once again, you could setup a minimal sharepoint site and then link to the sharepoint list. I have one such hybrid where my database pulls vender information from my company's sharepoint list. You will need to have some help from the sharepoint site admin.
I've even had my Sharepoint admin setup a simple list on the site that several people can add records to that I pull some information from as needed.

Here's a link to the basics for such a hybred Import from or link to a SharePoint list ACC2007 although this is for ACC2007, I don't think anything has changed.

For ACC2010, sharepoint is your only webbased option:
Creating Web Databases with Access 2010 and Access Services Office 2010
I think that holds true for ACC2013 - Note these are a really different beast. No VBA, You have to use Lookup fields at the table level instead of the normal relationships, and so forth.
BOL.