好郁闷的Access Update 语法老是说出错，我试了N+N+N次还是不行。

Question

如题：我的update 语句示例如下：1.update [Others] set 
[SecondsPerGame]=5, 
[ChipStepModel]=1, 
[AddPlayerScoreStepIndex]=2, 
[OverGameForPlayerScore]=20000, 
[FirstBetScore]=20, 
[AtLastReleaseScoreModel]=0, 
[KingCountModel]=0, 
[IsAutoContinueNextGameModel]=0, 
[MatchOrderModel]=0, 
[PrintModel]=0, 
[CoinRateModel]=1, 
[IsTurnOnGameForPrint]=0, 
[MaxHandselModel]=10000, 
[BankerWithhold]=5, 
[PlayeWithhold]=5, 
[PlayerMaxScore]=99999, 
[BeBankerContinueCount]=0, 
[BeBankerBaseScore]=2000, 
[BetedScoreToHandselPrecent]=0.5, where [OthersNumber] in (0)2.update [Others] on [OthersNumber] in (0) set 
[SecondsPerGame]=5, 
[ChipStepModel]=1, 
[AddPlayerScoreStepIndex]=2, 
[OverGameForPlayerScore]=20000, 
[FirstBetScore]=20, 
[AtLastReleaseScoreModel]=0, 
[KingCountModel]=0, 
[IsAutoContinueNextGameModel]=0, 
[MatchOrderModel]=0, 
[PrintModel]=0, 
[CoinRateModel]=1, 
[IsTurnOnGameForPrint]=0, 
[MaxHandselModel]=10000, 
[BankerWithhold]=5, 
[PlayeWithhold]=5, 
[PlayerMaxScore]=99999, 
[BeBankerContinueCount]=0, 
[BeBankerBaseScore]=2000, 
[BetedScoreToHandselPrecent]=0.5code]3.
[code=SQL]update [Others] set 
[SecondsPerGame]=5, 
[ChipStepModel]=1, 
[AddPlayerScoreStepIndex]=2, 
[OverGameForPlayerScore]=20000, 
[FirstBetScore]=20, 
[AtLastReleaseScoreModel]=0, 
[KingCountModel]=0, 
[IsAutoContinueNextGameModel]=0, 
[MatchOrderModel]=0, 
[PrintModel]=0, 
[CoinRateModel]=1, 
[IsTurnOnGameForPrint]=0, 
[MaxHandselModel]=10000, 
[BankerWithhold]=5, 
[PlayeWithhold]=5, 
[PlayerMaxScore]=99999, 
[BeBankerContinueCount]=0, 
[BeBankerBaseScore]=2000, 
[BetedScoreToHandselPrecent]=0.5, where [OthersNumber] = 03.[code=SQL]update [Others] on [OthersNumber] =0 set 
[SecondsPerGame]=5, 
[ChipStepModel]=1, 
[AddPlayerScoreStepIndex]=2, 
[OverGameForPlayerScore]=20000, 
[FirstBetScore]=20, 
[AtLastReleaseScoreModel]=0, 
[KingCountModel]=0, 
[IsAutoContinueNextGameModel]=0, 
[MatchOrderModel]=0, 
[PrintModel]=0, 
[CoinRateModel]=1, 
[IsTurnOnGameForPrint]=0, 
[MaxHandselModel]=10000, 
[BankerWithhold]=5, 
[PlayeWithhold]=5, 
[PlayerMaxScore]=99999, 
[BeBankerContinueCount]=0, 
[BeBankerBaseScore]=2000, 
[BetedScoreToHandselPrecent]=0.5code]四种都试过还是不行，还有更多种情况都试过还是不行。请问哪位大哥可以介绍一下Access下的数据库应用AQL语法格式。因为Access与SQL实在是半同半异，很难发现问题，而对Access不熟悉，那就更麻烦了。搞了好久还是没能解决。

Answer 1

update [Others] set 
[SecondsPerGame]=5, 
[ChipStepModel]=1, 
[AddPlayerScoreStepIndex]=2, 
[OverGameForPlayerScore]=20000, 
[FirstBetScore]=20, 
[AtLastReleaseScoreModel]=0, 
[KingCountModel]=0, 
[IsAutoContinueNextGameModel]=0, 
[MatchOrderModel]=0, 
[PrintModel]=0, 
[CoinRateModel]=1, 
[IsTurnOnGameForPrint]=0, 
[MaxHandselModel]=10000, 
[BankerWithhold]=5, 
[PlayeWithhold]=5, 
[PlayerMaxScore]=99999, 
[BeBankerContinueCount]=0, 
[BeBankerBaseScore]=2000, 
[BetedScoreToHandselPrecent]=0.5, where [OthersNumber] in (0)
多了逗号吧。

Answer 2

我不懂ACESS 所以我学习

Answer 3

Ma ma mi ya~~~我真滴多写了一个逗号~~~~晕死了。