ADO Error Attempting to Link Table




I am attempting to link a table from an user-level security database
to an unsecured databaes. The error I get is: Run Time Error
-2147467259, Could not find installable ISAM. I have done much
searching but I haven't come up with any solutions. Does anyone have
any ideas?

Option Compare Database
Dim adoCn As ADODB.Connection
Dim adoCat As New ADOX.Catalog
Dim adoTbl As New ADOX.Table
Private Sub createlink_Click()
'Create Link..
Set adoCat = New ADOX.Catalog
Set adoCat.ActiveConnection = adoCn
Set adoTbl.ParentCatalog = adoCat
adoTbl.Name = "LinkTable"
adoTbl.Properties("Jet OLEDB:Link Datasource") = "i:\eb.mdb;" & _
"User Id=psuer;Password=pswrd"
adoTbl.Properties("Jet OLEDB:Link Provider String") = "System
adoTbl.Properties("Jet OLEDB:Remote Table Name") =
adoTbl.Properties("Jet OLEDB:Create Link") = True
'Append the table to the tables collection
adoCat.Tables.Append adoTbl
End Sub


Upon reflection I came up with the following solution.

Create a user in both databases with same name/PID
In secure database, give the new user access only to the table of

Open my unsecure database with the following link:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "I:\em.mdb" /
WRKGRP "i:\e_sec_file.mdw" /user puser /pwd pswrd

I was then able to link/use the table of interest in the unsecure
database. I dustributed the link, and my users can continue to open
their unsecured database without a password as they always have.

However...I am open to better suggestions.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question