1. 获取最新添加ID
SQL:
直接获取, set rs = conn.execute("insert into [tableName](fieldName) values ('value') select ident_current('表名')) '或select @@identity as 'id'
获取: rs(0)
也可在执行rs.add 或insert into 后获取
--------------------------------------------------
ACCESS:
select Dmax('id', 'db_gallery')
2.删除表 Drop Table [tableName]
3.复制表结构和数据(不创建自增属性) select * INTO newTable From oldTable