link SQL Server table to MS Access

Is there a way with ADO/ADOX to link a SQL Server table to an MS Access database?

Thanks,
Thai

You can just link the table via an Access ODBC connection within Access itself or you could do it in VBA code.

I'm doing it through VB6, so Im hoping there is a way to do it with ADO.

Thanks,
Thai