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:
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?
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:
Code:
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
cnn.Close
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?