VBS script for writing, reading and deleting records in Access

Hia!

I'm a total amateur to VBS but need help on a VBS script.[:blush:]

What I need to is to write to a table in Access, then read these values and then delete records (rows) in Access.

By using help functions in WinCC I have this set up:

I created an Access database with the WINCC_DATA table and columns (ID,

TagValue) with the ID as the Auto Value.

Then I can write to Access by the following code:

Dim objConnection

Dim strConnectionString

Dim lngValue

Dim strSQL

Dim objCommand

strConnectionString = "Provider=MSDASQL;DSN=SampleDSN;UID=;PWD=;"

lngValue = HMIRuntime.Tags("Tag1").Read

strSQL = "INSERT INTO WINCC_DATA (TagValue) VALUES (" & lngValue & ");"

Set objConnection = CreateObject("ADODB.Connection")

objConnection.ConnectionString = strConnectionString

objConnection.Open

Set objCommand = CreateObject("ADODB.Command")

With objCommand

.ActiveConnection = objConnection

.CommandText = strSQL

End With

objCommand.Execute

Set objCommand = Nothing

objConnection.Close

Set objConnection = Nothing

This actually works fine, pure luck I guess![:P]

Can anyone help me with scripts for:

1. Reading one record (row) according to a ID number

2. Deleting the a record (row) according to a ID number

I would be very thankful for any help!

Best regards

ON

1. Reading one record (row) according to a ID number.

I'm close to what I need now, only thing I need is a simiar script that delete one record:

2. Deleting the a record (row) according to a ID number

If you Nemo or anyone can help me I would be a VERY happpy man on monday [:D], because this script is supposed to be finished by then!

ON