I need code to link table access 97 in another access 97 db ?

[FluFFy05]

I have 2 db, the 1 first is Read Only ans the second is me db, i need to attach(link) some tables from the first table

I know that it more simple directly in access, but i can't, because i have more than 1 db in read only and i want to attach(link) this table in the selectionned db in a scroll down menu !!

thanks a lot !!

 

[NickISD]

I assume your using ADO, is so set a reference to MS Jet and Replication Objects, this allows you to link tables.
Below is a small section of code I use, you should be able to pick the bits out you need to make it work for you.

Regards, Nick
For Each tblMST In cat.Tables
If tblMST.Type = "TABLE" Then
' ----- Append Linked Tables
Set cat1 = New ADOX.Catalog
Set tbl = New ADOX.Table
cat1.ActiveConnection = cn
tbl.Name = tblMST.Name
Set tbl.ParentCatalog = cat1
tbl.Properties("JET OLEDB:Link Datasource&quot = cMasterDB
tbl.Properties("JET OLEDB:Remote Table Name&quot = tblMST.Name
tbl.Properties("JET OLEDB:Create Link&quot = True
cat1.Tables.Append tbl
Set cat1 = Nothing
End If
Next