Read and write to an access database using Javascript

by

First, make sure that ‘/\’ and ‘\’ (in connection string) is just a typo in SO.

Second, here is a version of Delete command:

function DeleteRecord() {
var adoConn = new ActiveXObject("ADODB.Connection");
var adoCmd = new ActiveXObject("ADODB.Command");

adoConn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="\\dbName.mdb"");
adoCmd.ActiveConnection = adoConn;
adoCmd.CommandText = "Delete * From tblName Where FieldName="Quentin"";
adoCmd.Execute();

adoConn.Close();
}

And, Edit command (without looping -> updates all [matching] records):

function EditRecord() {
var adoConn = new ActiveXObject("ADODB.Connection");
var adoCmd = new ActiveXObject("ADODB.Command");

adoConn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="\\dbName.mdb"");
adoCmd.ActiveConnection = adoConn;
adoCmd.CommandText = "Update tblName Set FieldName="New Value" Where FieldName="Quentin"";
adoCmd.Execute();

adoConn.Close();
}

Please note, I have not tested this (do not have Access right now), so there might be some
syntax bugs…

Hope it works and helps.

More Related Contents:

  1. Countdown in javascript, database and php
  2. Can we protect against SQL-injection by writing Javascript code correctly? how? [closed]
  3. What is this JavaScript “require”?
  4. Mongoose and multiple database in single node.js project
  5. Leaderboard ranking with Firebase
  6. Is it possible to access an SQLite database from JavaScript?
  7. Export table from database to csv file
  8. How to handle an ActiveX event in Javascript
  9. opening Outlook through javascript
  10. What MySQL drivers are available for node.js? [closed]
  11. What is the best way to store private data in react-native?
  12. What is the difference between id and _id in mongoose?
  13. How to return only value of a field in mongodb
  14. create a text file using javascript
  15. ActiveX – Automation Server Can’t Create Object
  16. Using a WScript.shell activeX to execute a command line
  17. Writing UTF8 text to file
  18. Convert JSON to array in Javascript
  19. Is it possible to read substring from char to char
  20. React / JSX Dynamic Component Name
  21. Addition is not working in JavaScript
  22. RegEx for match/replacing JavaScript comments (both multiline and inline)
  23. Escape JavaScript in Expression Language
  24. What do empty parentheses () after a function declaration do in javascript? [duplicate]
  25. Why can I not use `new` with an arrow function in JavaScript/ES6?
  26. Preg_match to regex equivalent expression
  27. Axios posting params not read by $_POST
  28. Uncaught Invariant Violation: Too many re-renders. React limits the number of renders to prevent an infinite loop
  29. Sort an array in the same order of another array
  30. Get utc offset from timezone in Javascript

Leave a Comment