By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,369 Members | 1,230 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,369 IT Pros & Developers. It's quick & easy.

VB.NET: Create MSAccess Link Table:Error - Could not find installable ISAM.

P: 3
Following is my code:
Expand|Select|Wrap|Line Numbers
  1. Dim objCatalog As ADOX.Catalog
  2.         Dim objTableLink As ADOX.Table
  3.         Dim objADOConnection As ADODB.Connection
  4.         Try
  5.             objADOConnection = New ADODB.Connection
  6.             objADOConnection.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Database\abc.mdb;User Id=admin;Password=;")
  7.             objCatalog = New ADOX.Catalog
  8.             objCatalog.ActiveConnection = objADOConnection
  9.             objTableLink = New ADOX.Table
  10.             With objTableLink
  11.                 ' Name the new Table and set its ParentCatalog property
  12.                 ' to the open Catalog to allow access to the Properties
  13.                 ' collection.
  14.                 .Name = "ROLMembers"
  15.                 .ParentCatalog = objCatalog
  16.                 ' Set the properties to create the link table.
  17.                 .Properties("Jet OLEDB:Create Link").Value = True
  18.                 .Properties("Jet OLEDB:Remote Table Name").Value = "ROLMembers"
  19.                 .Properties("Jet OLEDB:Link Provider String").Value = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\Database\pqr.mdb;User Id=admin;Password=;"
  20.             End With
  21.             'Append the table to the Tables collection.
  22.             objCatalog.Tables.Append(objTableLink)
  23.             objADOConnection.Close()
  24.         Catch objException As Exception
  25.             lblMessage.Text = "Error:" & objException.Message
  26.             lblMessage.ForeColor = Color.Red
  27.         Finally
  28.             '' clean up
  29.             objTableLink = Nothing
  30.             objADOConnection = Nothing
  31.             objCatalog = Nothing
  32.         End Try
I get an error "Could not find installable ISAM." at line - objCatalog.Tables.Append(objTableLink)

Please advise.
Thanks in advance.
Jul 21 '09 #1
Share this Question
Share on Google+
3 Replies


P: 3
anyone there who can help me with the error I am getting.

Thanks in Advance.
Aug 9 '09 #2

MrMancunian
Expert 100+
P: 569
Have you already searched for this yourself? The first result in my Google query (Could not find installable ISAM.): http://support.microsoft.com/kb/209805

Steven
Aug 10 '09 #3

P: 3
@MrMancunian
Thanks Steve for your response.
I have already been through the article you have specified. The error remains the same. Please suggest alternative solution.

Regards,
Vee
Aug 11 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.