如何使用vb.net检查ms access数据库中是否存在记录？

Dim connectionString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\path\to\database.accdb"
Dim connection As New OleDbConnection(connectionString)

connection.Open()

Dim query As String = "SELECT COUNT(*) FROM TableName WHERE Condition"

Dim command As New OleDbCommand(query, connection)

Dim recordCount As Integer = CInt(command.ExecuteScalar())

If recordCount > 0 Then
    ' 记录存在
Else
    ' 记录不存在
End If

connection.Close()