|
-
Sep 13th, 2007, 10:55 PM
#1
Thread Starter
Lively Member
PLEASE HELP ON MY VB and VB SCRIPT
This is my code, it alway replied a error message, i cut the pix of error message, please help me.
I will use this to run and correct the MDB database on error on "AO is not index", this error occur when i done compacting MDB database.
Below is my script, i attached the picture message please help.
<SCRIPT LANGUAGE="VBScript">
<!--
Option Explicit
Const strDB = "C:\MYDATABASE.MDB"
const vpassadmin = "cristine"
Dim dbConnection
Set dbConnection = CreateObject("ADODB.Connection")
dbConnection.Open "Driver={Microsoft Access Driver (*.mdb)};Dbq=" &
strDB & ";Uid=Admin;Pwd=" & cristine & ";"
dbConnection.Execute "Drop Table MSysAccessObjects"
dbConnection.Close
Set dbConnection = nothing
MsgBox "You should now be able to open the database!"
-->
</SCRIPT>
<HTML>
<HEAD>
<TITLE> Database Correcting Error </TITLE>
</HEAD>
<BODY>
Click the button plz...
<HR>
<FORM>
<INPUT NAME = "process"
TYPE = "BUTTON"
VALUE = "Click here">
</FORM>
<HR>
</BODY>
</HTML>
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote