Connect to external DB

Question

Hi all,

I am currently using ODBC to connect to an external DB.

Is there any other alternatives in MS Access VBA to connect to an external DB?

Thanks

Deon

Answer 1

What type of db exactly?

What do you need to do with the db in question?

---

Daniel Pineault, 2010-2019 Microsoft MVP
Professional Support: http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net

Answer 2

DoCmd.Transfer*

CreateTableDef

At the end of the day they all do the same thing: create a linked table.

---

-Tom. Microsoft Access MVP

Answer 3

You can also use DSN less connections to setup your linked tables.