CODEWITHSUNDEEP
command-linejetms-jet-ace
Christopher Mahan
Christopher Mahan

Reputation: 7619

Does a command-line client exist for Microsoft Jet database engine?

Is there such a thing as a shell-based command-line client for Microsoft's Jet database engine?

Something similar to SQLite 3.x (sqlite3.exe) for SQLite.

Upvotes: 2

Views: 1125

Answers (3)

EJ Mak
EJ Mak

Reputation: 879

Entering the conversation here 10 years after the original question, but I've played with a couple of tools that should work:

  1. YouAccess (http://youaccess.sourceforge.net): "YouAccess is a free (donationware) lifesaver console µapplication intended for SQL management of Microsoft® Access™ databases from command line, including creating them."
  2. JetSQLConsole (https://sourceforge.net/projects/jetsqlconsole): "A command line/console interface for Microsoft Access databases, very similar to the MySQL client application."

Upvotes: 1

Tony Toews
Tony Toews

Reputation: 7882

Will PowerShell be suitable? Fellow MVP Richard Siddaway has started a very interesting series of blog postings on using PowerShell and Access. You can ignore the Office 2010 tag on his blog postings. Also note that I know nothing about PowerShell.

Upvotes: 3

Fionnuala
Fionnuala

Reputation: 91376

This may suit:

Cscript.exe is a command-line version of the Windows Script Host that provides command-line options for setting script properties.

With Cscript.exe, you can run scripts by typing the name of a script file at the command prompt. Like Microsoft Internet Explorer, Windows Script Host serves as a controller of Windows Script compliant scripting engines, but Windows Script Host has very low memory requirements. Windows Script Host is ideal for both interactive and non-interactive scripting needs, such as logon scripting and administrative scripting.

Windows Script Host supports scripts written in VBScript or JScript.

http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/wsh_runfromcommandprompt.mspx?mfr=true

Upvotes: 2

Related Questions