by Chri » Sun, 23 Jun 2002 12:07:19
by Vladimi » Mon, 24 Jun 2002 18:29:43
Quote:> Does anyone know how using ADOX to create a linked table
> to an external table in a database that has been secured
> with a user-level security that resides on read-only
> media.
by Chri » Fri, 05 Jul 2002 10:26:43
String").Value = "dBASEQuote:>-----Original Message-----
>Dim T As ADOX.Table
> Set T = New ADOX.Table
> With T
> .ParentCatalog = catDB
> .Name = Name
> .Properties("Jet OLEDB:Remote Table Name").Value
= UCase(Name) &
>"#DBF"
> .Properties("Jet OLEDB:Link Provider
Quote:>5.0;HDR=NO;IMEX=2;"
> .Properties("Jet OLEDB:Link DataSource").Value =
PathFile
> .Properties("Jet OLEDB:Create Link").Value = True
> End With
> catDB.Tables.Append T
> Set T = Nothing
>"Chris"
>.
1. Creating link to read only database using ADOX
I have set up procedure to create links in an Access database to
other Access DBs. It works fine normally, but if the remote database
being linked to is read only, it fails with error:
"-2147467259 (Cannot open database and it is already opened
exclusively or you need permission.."
Code used follows:
Set oTable(K) = New ADOX.Table
Set oTable(K).ParentCatalog = oCat
With oTable(K)
.Name = sTable(K)
.Properties("Jet OLEDB:Create Link") = True
.Properties("Jet OLEDB:Link Datasource") = sDBRemote
.Properties("Jet OLEDB:Remote Table Name") = sTable(K)
End With
oCat.Tables.Append oTable(K) [Fails on this line]
Set oTable(K) = Nothing
Set oCat = Nothing
TIA,
Matt
2. Error during backup, please help!
3. ADOX.Append Creates a Read-Only Linked Table to SQL Server 7.0
4. SQL problem
6. Visual Basic books reviewed
7. using adox to create table?
8. Select statement return error when creating a table using ADOX
9. Type is Invalid - When using ADOX to create a table
10. Oracle : Create Table using ADOX
11. creating a new table in Oracle data base using ADOX