tulnetdotcom
Posts: 26
|
| Posted: 09/21/2004, 1:45 AM |
|
I have MS Access database which contains one update query.
I want to run update query automatically when database is accessed/started by user.
Is it possible? How to do that?
Thanks and regards,
|
 |
 |
GeorgeS
Posts: 206
|
| Posted: 09/21/2004, 11:43 PM |
|
Yes, almost the same way you'd do it in Access:
<%
Dim CN
Set CN = Server.CreateObject("ADODB.Connection")
CN.Open = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db\your DB.mdb;Persist Security Info=False"
CN.Execute("gryInsertClientOrder") ' in " " are the names of your queries
CN.Execute("gryUpdateTrackNum")
CN.Execute("gryUpdateProdQTY")
CN.Close
Set CN = Nothing %>
Of course, you'll need write the condition statement  .
_________________
GeorgeS |
|
|
|
tulnetdotcom
Posts: 26
|
| Posted: 09/25/2004, 10:23 PM |
|
Thanks GeorgeS,
I really appreciate your help.
Thanks.
|
|
|
|
|
