Using ADOX to create linked table

Using ADOX to create linked table

Post by Chri » Sun, 23 Jun 2002 12:07:19



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.
 
 
 

Using ADOX to create linked table

Post by Vladimi » Mon, 24 Jun 2002 18:29:43


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 String").Value = "dBASE
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



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.


 
 
 

Using ADOX to create linked table

Post by Chri » Fri, 05 Jul 2002 10:26:43


Not linking to a dBase file.  Linking to an MS Access
file.

Quote:>-----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

String").Value = "dBASE
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"


:

>> 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.

>.

 
 
 

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

5. Using ADOX to Link Tables

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