I recently tweaked some code to connect to an access DB on Sharepoint with VBA using the connection strings here: SharePoint Connection String Samples - ConnectionStrings.com
The connection is working fine but I am getting an error with the insert statement. I think the problem is the GUID which I pulled from the Database Documentation in the Access Database Tools (once I launched the table from Sharepoint). Is there a way to check to see if this is the correct GUID for a sharepoint access table? I have found all sorts of instructions for Sharepoint Lists but not tables.
The connection is working fine but I am getting an error with the insert statement. I think the problem is the GUID which I pulled from the Database Documentation in the Access Database Tools (once I launched the table from Sharepoint). Is there a way to check to see if this is the correct GUID for a sharepoint access table? I have found all sorts of instructions for Sharepoint Lists but not tables.
Code:
strSQL = "INSERT INTO table (Reviewer, FeedbackDate, Project) " & _
"VALUES (" & txtReviewer & ", " & txtFeedbackDate & ", " & _
txtProject & ")"
Debug.Print strSQL
strConnection = "Provider=Microsoft.ACE.OLEDB.12.0;WSS; IMEX=0;RetrieveIDS=Yes;" & "Database=" & URL & ";table={F86062BB-3445-4B1E-9B72-00B10BAA05C6}; "
Debug.Print strConnection
Set cnn = New ADODB.Connection
cnn.Open strConnection
cnn.Execute strSQL, lngSuccess
