SQL和访问 [英] Sql and Access

问题描述

我有一个应用.在Access2007和我的数据库是sql.当我删除一行时，出现SQL错误消息，我无法删除该行，因为表格之间的关系(#547:)我想更改此信息.到 访问msgbox ！以及 sql 将不会再出现！

I have an app. in Access2007 and my db is sql. When i delete a row there is an error msg of sql that i cant delete this row because the relationships between tabels(#547: ) i want to change this messege  to Access msgbox ! and that msg of sql will not appear any more!

您能帮我吗?

推荐答案

嗨Michal，
我不确定这是否是您提出问题的合适论坛.无论如何，这里有一些对您有用的链接； --
http://msdn.microsoft.com/en-us/library/bb258159.aspx

Hi Michal,
I'm not sure that this is the right forum for your question. Anyway here are some useful links for you; -
http://msdn.microsoft.com/en-us/library/bb258159.aspx

> http://stackoverflow.com/questions/330937 /access-vba-可以重置错误处理

一些有关错误处理的通用建议是在系统发现错误之前自己捕获错误.这使您的错误处理更加优雅和用户友好.

Some generic advice for error handling is trap the error yourself before the system discovers it. This enables your error handling to be much more graceful and user friendly.

例如，如果用户单击删除按钮，则在执行实际删除之前，编写代码以测试有效删除.

For example if a user clicks on a delete button, write code to test for a valid delete before performing the actual delete.

亲切的问候，

基兰.

这篇关于SQL和访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！