Solve : MSAccess from a batch file?

1.	Solve : MSAccess from a batch file?
Answer» Is it possible to retrieve or update MSAccess records from a BATCH FILE. It needs to work over a Telnet Server so even a VBS script will not work. Here is a simple VBS script that I am testing with. I need the equivalent in a batch script. Set MyConn = CreateObject("ADODB.Connection") MyConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\data.mdb" MyConn.Execute "UPDATE dbo_SerialNumbers SET ShipNo = 99 WHERE SerialNo = 66" MyConn.Close The telnet Server is RUNNING on Server 2000 The MSAccess is XP The Client is a handheld barcode SCANNER running Windows CEThere is no chance - batch files cannot access com objects If you cant use VB, then I doubt you can use powershell either

Discussion