最近はこうだな、、
DoCmd.DeleteObject acTable, "T_社員" DoCmd.TransferDatabase acLink, "ODBC Database", "ODBC;Driver={SQL Server};Trusted_Connection=Yes;Server=server1;DATABASE=db1", acTable, "T_社員", "T_社員", , True
最近はこうだな、、
DoCmd.DeleteObject acTable, "T_社員" DoCmd.TransferDatabase acLink, "ODBC Database", "ODBC;Driver={SQL Server};Trusted_Connection=Yes;Server=server1;DATABASE=db1", acTable, "T_社員", "T_社員", , True