My SellerDeck Account | Newsletter | Free Trial

Community and Knowledge Base

Go Back   Sellerdeck Community > Knowledge Base > Tips and Tricks for Templates (v7 and Lower)

Search powered by Google
Register FAQ Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Search this Thread Rating: Thread Rating: 1 votes, 5.00 average. Display Modes
  #1  
Old 22-Nov-2009, 01:55 PM
KB KB is offline
Administrator
Join Date: Nov 2009
Posts: 1,012
Thanks: 0
Thanked 34 Times in 29 Posts
I've been given a SQL query to run on my database but I don't have MS Access. How ...

I've been given a SQL query to run on my database but I don't have MS Access. How can I apply it?

You can run a SQL query on the ActinicCatalog.mdb file without MS Access by doing the following:

* create a blank text document
* paste the following into the file:

'my shop database is located at:
mydb = "C:\Documents and Settings\All Users\Documents\Actinic v9\Sites\site1\ActinicCatalog.mdb"

Set OBJdbConnection = CreateObject("ADODB.Connection")
OBJdbConnection.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & mydb
SQLQuery = " "
Set Result = OBJdbConnection.Execute(SQLQuery)
OBJdbConnection.Close


msgbox("done")

* change the 'mydb' value to the location of the ActinicCatalog.mdb file for the correct site
* place the SQL that you have been given in the 'SQLQuery' line between the " and " (any line breaks must be removed)
* close and save the file
* rename the file to something like 'SQLUpdate.vbs' (the icon should look like )
* ensure that SellerDeck is closed and ALWAYS back up your database before you run the file
* double-click on the file to run it
* you will get a 'done' message when it is finished
* you can then re-open SellerDeck.


With thanks to Gabriel Crowe of Interact Studio for providing this solution.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT. The time now is 06:01 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.