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