更新查询以访问数据库未运行 [英] Update query for access DB not running

问题描述

你好朋友，

我正在运行查询以更新访问Db中的记录，但显示错误为;-

更新语句中的语法不正确"

查询如下:-

更新UserMaster SET UserName =" a，密码=" a，UserType =" admin，First =" ="admin"，LastName ="Varun"，备注=测试''，DateAdded =''2011/10/7 7:31:23 AM''，其中UserID = 2''

我做错了我无法得到的地方.

请帮助

Hello friends,

I am running a query for updating of record in the access Db but it is showing an error as;-

"Incorrect syntax in Update Statement"

the query is as follows:-

"update UserMaster SET UserName=''a'',Password=''a'',UserType=''admin'', FirstName=''admin'',LastName=''Varun'',Remarks=''a test'',DateAdded=''10/7/2011 7:31:23 AM'' where UserID=2"

where i am doing wrong i am not able to get.

Kindly help

推荐答案

您需要将日期更改为#10/7/2011 7:31:23 AM#.
``10/7/2011 7:31:23 AM''在MS Access中不起作用.它可在SQL Server和其他服务器中使用.

you need to change date to #10/7/2011 7:31:23 AM#.
''10/7/2011 7:31:23 AM'' does not work in MS Access. It works in SQL Server and others.

首先您已测试了连接????
您如何连接到数据库记录集?

first have you tested your connection???
how are you connecting to the db record sets???

这篇关于更新查询以访问数据库未运行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！