Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pithhelmet
Posting Yak Master
183 Posts |
 Posted - 2009-07-04 : 20:48:16
|
| Hi everyone,Kinda a different question...We deploy an access database with our application, but not the whole version of access. I need to perform a query (update) from the command line against the mdb database.is there anyway to accomplish this?thankstony |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2009-07-05 : 20:54:56
|
| You'll need to use ODBC.I would write a short bit of VBScript to create a connection to the MDB and then execute the query using an ADO Command.You don't need Access installed for this; you just need the data access components that must be there anyway if your app uses Access.Hope this helps,Tim |
 |
|
|
pithhelmet
Posting Yak Master
183 Posts |
Posted - 2009-07-06 : 07:27:26
|
| Hi TimThanks for posting.I do not know the 1st thing about vbscript... Would you possibly have a short template that simply updates the value of a field in a table.I can, of course, insert the specific code to complete my needed tasks.Thanks againtake caretony |
|
|
|
pithhelmet
Posting Yak Master
183 Posts |
Posted - 2009-07-06 : 07:33:41
|
| I did a quick google search on vbscript....I am confused on what IDE/enviroment you would use to execute this vbscript code from within...i do not have any tools on the laptop other than ODBC and the MDB loaded on them.can this be accomplished within a batch file?sorry for the newbie questions.take caretony |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2009-07-06 : 21:29:37
|
| Tony, You should be able to run VBScript using Windows Scripting Host (WSH) that should be installed by default in Windows.Just create the script, save it as a .vbs file and then execute it (by double-clicking). The script would look something like this:Dim cnSet cn = CreateObject("ADODB.Connection")cn.Open <your connection string>cn.Execute <your sql statement>cn.Close |
|
|
|
pithhelmet
Posting Yak Master
183 Posts |
Posted - 2009-07-07 : 09:47:46
|
| rock on!!!I'll try it in a few momentsthankstony |
|
|
|
|
|
|
mdb command line query