Pls Help.!!! I m getting error as Runtime error '-2147467259 (8000500)
cannot find installable ISAM
Printable View
Pls Help.!!! I m getting error as Runtime error '-2147467259 (8000500)
cannot find installable ISAM
also when i write normal conncection program!! it gives me error!! as
Compile error :
User defined type not defined!!
my code is
Private Sub Command1_Click()
Dim tbl As New Table, cat As New ADOX.Catalog
' 1) Create the DataBase
cat.Create "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "Clients.mdb" & ";"
' 2) Create Table name "ClientsInfo"
tbl.Name = "ClientsInfo"
' 3) Add 3 Fields
tbl.Columns.Append "Name", adVarWChar, 50 'Text
tbl.Columns.Append "Age", adInteger 'Number
tbl.Columns.Append "Address", adLongVarWChar 'Memo
' 4) Save the Table to the DataBase
cat.Tables.Append tbl
'*********************** Use this to Open and/or Modify an existing DataBase **************
'Open the DataBase
'cat.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & App.Path & "\Clients.mdb" & ";"
'*********************************************************************************
MsgBox "Clients.mdb Created."
End Sub
Does it error on this line?Quote:
Originally Posted by myst
If so, you are missing a reference.
Also, I have split your posts our of this thread into its own thread.
Your questions are not related to the other thread, and, the other thread was created by another member, so, for you issues, you should have your own.