Running Script File in MS Access

[ko]

Can someone tell me how a database script file runs in MSAccess 97/2000.<br><br>Regards

 

[DougP]

Not sure what you mean by a database script file?<br>Are you talking about VBA?<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[ko]

Script file is the file in which you write the database schema. I am an Oracle professional. There if you have the database script file(preferably with sql extension) then by giving a single command you can create tables, constraints, references and stuff like that. Actually the script file holds all the commands for the creation of the database. <br>I hope you get my point.<br><br>Regards

 

[JimConrad]

Search for &quot;Data definition query&quot; using Access Help system. <p>Jim Conrad<br><a href=mailto:jconrad3@visteon.com>jconrad3@visteon.com</a><br><a href= > </a><br>

 

[ko]

Hi All<br><br>Data definition query does not answer my question. There should be command in MS Access 97/2000 that can execute the script present in the script file.<br><br>Regards

 

[JimConrad]

Access will not run an external script file.&nbsp;&nbsp;You can however, copy your script into an Access query and then run the query.<br><br>Use &quot;pass-thru&quot; query, if the commands need to run outside of JET (the database used by Access). <p>Jim Conrad<br><a href=mailto:jconrad3@visteon.com>jconrad3@visteon.com</a><br><a href= > </a><br>

 

[ko]

Hi All<br><br>Access returns an error if you try to run more than one query. This I tried earlier while copying whole & part of the script into the design view of the query object.<br><br>Pass-thru query does not answer my question since I am trying to run the script from a text file.<br><br>What I think right now is that Access will not be able to run the script file.<br><br>Thank you all for participating.<br>Best Regards<br>Obaid