473,322 Members | 1,911 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

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

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
3 4899
Vee007
3
anyone there who can help me with the error I am getting.

Thanks in Advance.
Aug 9 '09 #2
MrMancunian
569 Expert 512MB
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
Vee007
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

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

Similar topics

10
by: Brent | last post by:
Hi, my asp.net c# app is trying to connect to an Access database with a password and am I getting the error.. Could not find installable ISAM. . If I connect to one without a password it works...
1
by: Karl Irvin | last post by:
In the module below, I get a "Could not find installable ISAM" error on the tdf.refresh link. The NewConnection refers to a valid database/table. My References include VBA, Access 9.0 Object...
2
by: Horst Walter | last post by:
I am using C# / ADO.NET to create an Excel sheet: This connection string works: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filename + ";" + "Extended Properties=Excel 8.0;"; This...
6
by: Robert Lawson | last post by:
I continue to get the below error message when trying to load a aspx file. Could someone please point me in the right direction for solving this? I'm trying to access an access data base and I'm...
1
by: JP Lacasse | last post by:
I translate a web application from ASP to ASP.NET and I keep getting the following error: Could not find installable ISA I used the same ConnectString ("DBQ=" &...
1
by: Sandeep | last post by:
Hi I m using following lines to access a MsAccess Database its there conn=new OledbCOnnection("Provider=Microsoft.Jet.OLEDB.4.0;DataSource=c:\\DB1.MDB;Jet OLEDB:Max Buffer Size=256;")...
2
by: ibeetb | last post by:
When using ADO.NET, here is my code to bring in a table from EXCEL: Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" _ & "Data Source=C:\Inetpub\wwwroot\ExcelData.xls;" _ ...
2
by: orandov | last post by:
I am trying to connect to an Access 2000 database from VB.NET and I get this error "Could not find installable ISAM." I don't think there is anything wrong with my connection string. ...
7
Walt in Decatur
by: Walt in Decatur | last post by:
I'm trying to use this method to copy an range in Excel workbook that is closed to the one that's open. I'm using the following code, which gets the "Can't find installable ISAM" error when I get to...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.