Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
Sub Test1() Dim connAdo As ADODB.Connection Dim rstTest As ADODB.Recordset Set connAdo = New ADODB.Connection connAdo.Open ("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\develop\database3.accdb;Persist Security Info=False;") Set rstTest = New ADODB.Recordset rstTest.Open "table1", connAdo, adOpenDynamic, adLockPessimistic rstTest.MoveFirst rstTest.Fields("field1").Value = "Test" rstTest.Save '' THIS LINE CAUSES RUNTIME ERROR End Sub
|Install MS Office 2016 and uninstall MS Office 2010||3||66|
|In search of x17-22375.exe||2||24|
|Outlook 2016 - Change time of existing recurring appointment||2||19|
|VBA - If Bookmark = "XXBOOKMARKXX" then||15||23|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
8 Experts available now in Live!