传递SQL查询 - 建议 [英] Pass-thru SQL queries - Advice

问题描述

大家好，

出于安全考虑，我必须建议新客户关于后续部分访问数据库。由于问题是安全问题，我假设他们不想将表格链接到前端。我知道我可以使用ADO来创建许多必需的连接，但我正在考虑使用Pass-thru SQL查询来解决一些问题。


但是，我知道它们的使用存在问题而我只是想知道它们是什么。欢迎任何其他有关后端访问数据库以提高安全性的建议。


Mary

Hi everyone,

I have to advise a new client regarding backending some access databases for security reasons. As the issue is one of security I''m assuming they won''t want to just link the tables into the front end. I know I can use ADO to make a lot of the required connections but I am considering using Pass-thru SQL queries for some issues.

However, I know there are problems with their use and I''m just wondering what they are. Any other advise regarding backending an access database to improve security are welcome.

Mary

推荐答案

大家好，

出于安全考虑，我必须建议新客户关于后续部分访问数据库。由于问题是安全问题，我假设他们不想将表格链接到前端。我知道我可以使用ADO来创建许多必需的连接，但我正在考虑使用Pass-thru SQL查询来解决一些问题。


但是，我知道它们的使用存在问题而我只是想知道它们是什么。欢迎任何有关后端访问数据库以提高安全性的建议。


Mary

Hi everyone,

I have to advise a new client regarding backending some access databases for security reasons. As the issue is one of security I''m assuming they won''t want to just link the tables into the front end. I know I can use ADO to make a lot of the required connections but I am considering using Pass-thru SQL queries for some issues.

However, I know there are problems with their use and I''m just wondering what they are. Any other advise regarding backending an access database to improve security are welcome.

Mary

Mary，

我不是安全问题的专家，但我想成为:)

你能解释一下为什么连接BE的表不如其他东西安全吗？

Mary,
I am not an expert in security issue, but I want to be :)
Could you explain why linking the tables from the BE is less secure than the other things ?

< br>

玛丽，

我不是安全问题的专家，但我想成为:)

你能解释一下为什么从BE链接表不如其他东西安全吗？

Mary,
I am not an expert in security issue, but I want to be :)
Could you explain why linking the tables from the BE is less secure than the other things ?

如果链接后端的表，它们仍然可以导入到另一个数据库或至少链接到。

If you link the tables in the backend they can still be imported to another database or at the very least linked to.

如果链接后端的表，它们仍然可以导入到另一个数据库或至少链接到。

If you link the tables in the backend they can still be imported to another database or at the very least linked to.

感谢您的澄清。看到这个帖子的演变会很有趣。

Thanks for the clarification. It would be interesting to see the evolution of this thread.

这篇关于传递SQL查询 - 建议的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！