Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Outlook owa - how to embed an email from my Inbox into a new email||4||26|
|Track use of a script by logging username, date & time to an excel file.||4||46|
|how can i return the name of color from the cell background?||8||32|
|VBA to toggle change the excel table structured reference to explicit cell references||3||11|
Join the community of 500,000 technology professionals and ask your questions.