Think I gottit now. The following just created a linked table to the database:
Code:
Function LinkTables()
Dim DB As Database, tDef As TableDef
Set DB = CurrentDb
Set tDef = DB.CreateTableDef("Test")
tDef.Connect = "ODBC;Driver={Microsoft ODBC for Oracle};Server=Orcl;UID=user;PWD=pass"
tDef.SourceTableName = "MV_OWNER.GEO_CODES_MV"
DB.TableDefs.Append tDef
End Function
Table shows what it should now.
rpeare I thank you for your time and expertise here. This is why this forum is invaluable.
Thank you again.