I am using access VBA and DAO to programmatically create linked tables.

I build a string like this:

strConnect = "ODBC;DRIVER=SQL Server;Database=mydatabase;Server=myserver;

I then create the TableDef:

Set td = CurrentDb.CreateTableDef(stlocalTableName, dbAttachSavePWD, stRemoteTableName, strConnect)

I then append the TableDef:

CurrentDb.TableDefs.Append td

I want the tables created / linked under an AD Group instead of my user.

I have tried numerous options and all I ever see when I create the table is:

...;UID=myuser;Trusted_Connection=Yes;..

Is it possible to link a table using an AD Group instead of an Individual user?

P.S. The AD group has datareader and datawriter rights to the database.