Set rs = New ADODB.Recordset
rs.CursorType = adOpenKeyset
rs.LockType = adLockOptimistic
rs.Open "select * into " + newtablename + " from system where false", cnn, , , adCmdText
用ClientDC的这个办法较好,不过,还得在Access中手动设置新表的主键
Set rs = New ADODB.Recordset
rs.CursorType = adOpenKeyset
rs.LockType = adLockOptimistic
rs.Open "select * into " + newtablename + " from system where false", cnn, , , adCmdText