Access编号重新开始
先删除所有记录
delete from [SaleSheet]
ALTER TABLE [SaleSheet] ALTER COLUMN [sid] COUNTER (1, 1)
另:Access不支持join简写,应该写成inner join
Access编号重新开始
先删除所有记录
delete from [SaleSheet]
ALTER TABLE [SaleSheet] ALTER COLUMN [sid] COUNTER (1, 1)
另:Access不支持join简写,应该写成inner join
转载于:https://www.cnblogs.com/yuteng/archive/2010/06/14/1758281.html