数据恢复提示错误

wangzeyang

点击强制还原数据库，仍然提示该错误。如图

weiyanmin

为什么我会得到一个0x80040e14的错误信息？

This error is thrown up by the underlying OLEDB Provider. The actual error message is:
The command contained one or more errors
The error message that you see on the screen will vary depending on the MDAC that you have installed and the actual cause of the error.

There are a number of possible causes:
Scenario 1 - Syntax error in FROM clause
Scenario 2a - Syntax error in INSERT INTO statement
Scenario 2b - Syntax error in UPDATE statement
Scenario 3a - Syntax error (missing operator) - caused by ' mark
Scenario 3b - Syntax error (missing operator) - incorrect delimiters
Scenario 4 - Syntax error - division by zero error
Scenario 1 - Syntax error in FROM clause
This commonly occurs when you have a table name that is a reserved word or your table name contains a space (eg "table 1").

Certain words (like table, field, date, select, password, level etc) are reserved by either ADO, OLEDB or by Access for use as commands or system objects.

You can get a list of reserved words in Access from the online help. The Microsoft Platform SDK outlines ADO/OLEDB reserved words.

You should never use these words as names for tables or fields nor should you have spaces in your tablenames. It is recommended that you rename your offending tables/fields and adjust your SQL statement accordingly.

If this is not possible you should enclose your offending table names with [ ] marks, eg
SELECT field1
FROM [table]
Scenario 2a - Syntax error in INSERT INTO statement.
This commonly occurs when your field name is a reserved word (see scenario 1 above). Adjust your field names and SQL statement accordingly and you should avoid the problem.

If you can't adjust your fieldnames you can use [ ] marks to delimit the field names, eg
INSERT INTO table1
([field], [password])
VALUES ('value1', 'value2')
Scenario 2b - Syntax error in UPDATE statement.
This has the same cause as Scenario 2a immediately above.

Scenario 3a - Syntax Error (Missing Operator)
This is commonly caused when some value that you are trying to SELECT/UPDATE etc contains a single quote mark. The error that you receive looks like:
Microsoft JET Database Engine (0x80040e14)
Syntax error (missing operator) in query expression 'Name = 'O'Malleys''.
Because of the presence of the ' in the name O'Malleys the database engine thinks that you are constructing a WHERE clause like:
WHERE name = 'O'
and doesn't know what to do with the rest of the name (Malleys). To solve this problem you need to use the Replace() function and replace all single quotes with two single quotes. It is recommended that you put the Replace() function above into a user-defined function and call as necessary within your page. Click here for an example of such a function.

Scenario 3b - Syntax Error (Missing Operator) - incorrect delimiters
This error can also be caused when attempting an INSERT or UPDATE SQL statement and you have used incorrect delimiters.

Field Type (Access) Field Type (SQL Server) Delimiter
Text Char, varChar '  
Numeric Any numeric type <none>  
Date/Time Any Date/Time # (Access), ' (SQL Server)  

UPDATE table1
SET someTextField = 'someTextValue',
someNumericField = 5
someDateField = #01/01/2000#
Scenario 4 - Division by Zero
Dates need to be delimited with # marks when passed to the Jet Database Engine. This marks them as a date literal. Access then takes the literal date and converts it into a number. Alternatively, you can pass an integer to Access, and Access will construct a date based on that number.

However if you do this:
SELECT field1
FROM table1
WHERE field1 = 01/01/00
Access will treat this as an integer - namely 1 divided by 1 divided by 0, resulting in a division by zero error. Instead you need to write your SELECT query as:
SELECT field1
FROM table1
WHERE field1 = #01/01/00#  
网友评论加入收藏打印本文上一篇：发送带附件的HTML格式邮件例程
下一篇：动态显示图片的函数（显示广告条）
>> 关于0x80040e14错误 的相关文章
qq直播官方网站下载？ppmate播放器下载
赛博qq2009传美版:腾讯QQ2009(亲测完美显IP) 传美版...
Dreamweaver MX进阶教程（十）制作居中的网页...
做标本浸泡罐 [5]
用Dreamweaver MX建设神奇网页图片超链接
FLASH MX2004体验一：在用CSS格式化Flash文本...
FLASH MX2004体验二：定制组件外观
Flash MX 2004:在2个UI组件间进行数据绑定
Flash MX组件之一 组件的概念
用 Fireworks 画金属小球
Fireworks MX 2004等高渐变填充
Dreamweaver MX 2004新功能
关于0x80040e14错误 在百度baidu上的更多资料
关于0x80040e14错误 在谷歌google上的更多资料
关于0x80040e14错误 在雅虎yahoo上的更多资料
关于0x80040e14错误 在搜搜soso上的更多资料
关于0x80040e14错误 在MSN搜索上的更多资料
  
评论内容只代表网友观点，与本站立场无关！ 查看完整内容   
    我来评两句 用户名称  评分  100 85 70 55 40 25 10 0 验证码   

最多500字。当前字数：0
   



ASP实现远程保存图片的实例源码
ASP编程入门进阶（五）：内置对象Response
可缓存的CMS系统设计(1)
[.net]windows控件实现水印分类导航ASP专区PHP专区JSP专区NET专区XML专区CGI专区本类阅读排行本类推荐排行
菜鸟学 DreamWe...
ASP编程入门进阶...
利用ASP和Acces...学校教学网站应用设计
股票网站方案设计
win2000 server 全部安全补丁
身份证号码验证函数
旅游网站应用设计
ADO连接数据库字符串大全（VP,Ex...
菜鸟学 DreamWeaver MX 做 ASP
[ASP]GB2312转UTF-8
ASP操作Excel技术总结
医院管理系统(HIS)应用设计
利用客户端js实现汉字简体繁体转...
WEB打印设置解决方案二（利用Scr...
本类阅读排行本类推荐排行 ASP实现远程保存...ASP实现远程保存图片的实例源码
随机推荐文章
ASP.NET中的Cod...
十天学会ASP之第...
asp.net利用RAR...实现有管理功能的ASP留言板
怎样给文件加密最安全(一种方法)...
DVBBS等论坛存在Cookies偷取漏洞...
ASP判断E-Mail的合法性，以及过滤...
压缩并修复Access数据库(推荐)
用好ASP.NET 2.0的URL映射
介绍一种效率极高的分类算法
如何在Web页面中集成文件上传功能...
无组件图片与文本同步存入数据库...
用ASP统计用户在站点的停留时间(...
有关ASP的一些常见问题（四）
堵住ASP漏洞
推荐信息-
当前在线人数

weiyanmin

网上也搜不出结果来，qq和我联系：419634023

wangzeyang

谢谢韦工，以解决！

haifeng20c

如何解决的？能详细说一下吗。数据库表结构不一样，恢复会有问题。

wangzeyang

恢复数据之前，忘记停止CAXA图文档的相关服务。恢复数据时提示，提示如图的错误。