Using ADO connection to insert records into Sharepoint 2010 Access DB (1 Viewer)


New member
Local time
Yesterday, 22:29
Jan 15, 2013
First post so hello to all.

I wrote some code for a project awhile back which does the following:

(a) creates a SQL String from a user form (strSQL is the string variable) and then
(b) inserts the string into a Access Database using an ADO conenction

This all works fine:

 strSQL = "INSERT INTO FeedbackDB " & "(FeedbackDate, Project, BriefComments) " & "VALUES (" & txtFeedbackDate & ", " & _
    txtProject & "," & txtBriefComments & ")"
strPath = "C:\Documents and Settings\jdscranton\My Documents\FeedbackDatabase.accdb"
    strConnection = "Provider=Microsoft.ACE.OLEDB.12.0;" & " Data Source = " & strPath
    Debug.Print strConnection
    Set cnn = New ADODB.Connection
    cnn.Open strConnection
    cnn.Execute strSQL, lngSuccess

However, the accdb is now being integrated into Sharepoint 2010 as a web database.

Can I use a ADO connection to insert a new record into a web database?

If so, what would the strPath be?

If not, what are some suggestions to accomplish the same goal?

Users who are viewing this thread

Top Bottom