A couple of examples (one via ADO, the other using DAO); with ADO, you are limited to creating the table via an SQL statement, whereas DAO allows you to play with the Access data object ...

My old friends, I would appreciate your assistance in solving my current dilemma. I'm looking to make an access report that is dependent on data from a remote SQL Server. Additionally, I want to run ...