Collecting data from emails

[Voodeux2014]

I am trying to find a way to create a form of sorts that I can send out via email to have user's fill out and automatically will update my access database. I have Access 2013 and I do not see the feature that I saw in 2007/2010.

[ranman256]

Is it possible NOT to use email , but rather give them an access form to open and add the data? (a user entry sceen only)

[June7]

Right, MS mostly eliminated Collect Data from 2013. If you still have 2007/2010 available can build db with Collect Data then open in 2013 and it is supposed to work, cannot build Collect Data in 2013.

Only alternative I know is lots of VBA code to pull data from email.

Who are these 'users' - remote clients, customers - not staff connected to your network?

[Voodeux2014]

All the users would be direct employees of the company. Not everyone has the Microsoft Access program on their systems as all systems were purchased at different times and what not. I see that I could create an excel sheet and have it linked to the database, but then it would cancel out the opportunity to use the actual database to make changes.

[ranman256]

If not, I built a form in Outlook and on SAVE click:

(be sure to load ADO library in the VBE menu, TOOLS, REFERENCES..

'---------
Public Sub SaveRec()
'---------
Dim sSql As String
Dim cn As New ADODB.Connection
  'collect all the text box values to SQL
sSql = "INSERT INTO tData ( DbtrName, DbtrAddr, DbtrZip ) values(" & _
"'" & txtName & "'," & _
"'" & txtAddr & "'," & _
"'" & txtPhone & "')"
SaveADO sSql
End Sub
'---------
Public Sub SaveADO(ByVal pvSql As String)
'---------
Dim con As ADODB.Connection
Dim DB
Dim vProvid
Set con = New ADODB.Connection
Set rs = New ADODB.Recordset
 
 vProvid = "Microsoft.Jet.OLEDB.4.0"
 uid = ""
 pwd = ""
 DB = "\\server\folder\MyDatabase.mdb"
     
With con
    .Provider = vProvid
    .Properties("User ID").Value = uid
    .Properties("Password").Value = pwd
    
    .Open "Data Source=" & DB
End With
 
con.Execute pvSql
con.Close
End Sub

[June7]

If there are multiple users, should split database. Each user should run their own copy of the frontend. If users do not have full Access, can publish the frontend as a runtime version. I am not sure if each user will need to download the free Runtime app or if it is packaged when you convert the db http://www.microsoft.com/en-us/downl....aspx?id=39358