Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
The SQL command looks something like this:
Private Function storeData(ByVal mySql As String) As Boolean Dim ret As Boolean = False Dim ac As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & myPath) Try Using ac Dim myCommand = New System.Data.OleDb.OleDbCommand(mySql, ac) myCommand.Connection.Open() myCommand.ExecuteNonQuery() myCommand.Connection.Close() End Using ret = True Catch ex As Exception MsgBox("There is something wrong." & _ vbNewLine & ex.ToString, MsgBoxStyle.Exclamation, "SQL Error") End Try Return ret End Function
and seem to work fine, and when I browse through the table using my program after having entered a new record, I can see the new records. But when I close the program and reopens it, or query the DB from outside, the newly entered data have disappeared. What am I missing? Do I need som kind of file save or commit or something?
Insert into NAD(Name,Address,Postnumber,Telefonnumber,Epostaddress,Webpage) values('Thor','Oslo','0575','999 88 777','email@example.com','www.web.com');
|Change AD password via MS Access DB||2||17|
|SQL syntax in VB.net||5||28|
|MS access report - how to make a heading be zero when no data exists||17||32|
|Access Query based on a Form Field||2||15|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!