Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Read,write and delte from access by strSQL
Dim objConnection Dim strConnectionString Dim strSQL Dim objCommand strConnectionString = "Provider=MSDASQL;DSN=SampleDSN;UID=;PWD=;" strSQL = "Delete from WINCC_DATA Where ID=1" Set objConnection = CreateObject("ADODB.Connection") objConnection.ConnectionString = strConnectionString...- vadarv
- Post #3
- Forum: Microsoft: Access Other topics
-
read, write and delte in access strSQL
Hia! I'm a total amateur to VBS but need help on a VBS script. This is used in a HMI system from Siemens called WinCC, used for process viewing and control. 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...- vadarv
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
-
Read,write and delte from access by strSQL
Hia! I'm a total amateur to VBS but need help on a VBS script. This is used in a HMI system from Siemens called WinCC, used for process viewing and control. 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...- vadarv
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
-
Reading, writing and deleting records in access database, Please help!
Hia! I'm a total amateur to VBS but need help on a VBS script. This is used in a HMI system from Siemens called WinCC, used for process viewing and control. 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...
