Link/Unlink table from one Access app to another

Topic

New Reply

I know how to dynamically link and unlink tables from SQL Server in Access, but am stuck on how to do the same thing from one Access app to another. Not sure what connection method to use, etc. for example, Link SQL Server table into access like so:

Code:

            Dim tdf As DAO.TableDef
            Dim CONSQLSVR As String
    
            CONSQLSVR = "ODBC;Driver=SQL SERVER;SERVER=;UID=;PWD=" & Password & ";Database=;"

            Set tdf = CurrentDb.CreateTableDef("dbo_")
            tdf.Connect = CONSQLSVR
            tdf.SourceTableName = "dbo."
            
            CurrentDb.TableDefs.Append tdf

As you can see, i use ODBC to load a table and CreateTableDef to give it a name when loading. Not sure how to do the same thing in Access; I suppose it should be a lot simpler?

TIA

Reply | Quote

Replies

Hi Steve,
Are you wanting to link to tables in another Access database, or are you wanting to link SQL Server tables to another Access database?

Reply | Quote

Problem solved – issue no longer relevant. Thanks!

I want to link to tables in another Access database – thanks!

Reply | Quote