输入特定密码时从msaccess删除数据 [英] deleting data from msaccess on entering a specific password

问题描述

Hi Team，



我为客户开发了一个应用程序，使用msaccess作为后端，vb.net作为前端。应用程序根据需要工作得非常好。



客户端有以下要求 - 保留msaccess（数据库文件）的密码，这样任何用户都无法直接打开文件从我的电脑。 [轻松实现]



他的进一步要求是在同一个文件上保留2个密码 - abc和xyz

现在如果有的话一个通过mycomputer打开这个文件，访问文件将要求输入密码 - 如果输入了abc，那么它应该显示所有细节，但是当输入xyz时，msaccess应该运行一个脚本，该脚本将从表中删除某些数据并显示剩余的详细信息。 />


请建议一种如何实现此目的的方法。

解决方案

如果您只使用MS Access，我建议你阅读：使用参数在运行查询时请求输入 [ ^ ]。

 PARAMETERES [密码]  char ; 
  DELETE  * 
  FROM  TableName 
  WHERE  [密码] = ' 密码' 

Hi Team,

I have developed an application for a client using msaccess as backend and vb.net as front end. The application is working perfectly fine as required.

The client has following requirement - keeping a password for the msaccess (database file) so that no user can open the file directly from my computer. [easily achievable]

His further requirement is keeping 2 password on the same file - "abc" and "xyz"
Now if any one open this file through mycomputer and access file will ask for password - if abc is entered then it should show all details but when xyz is entered msaccess should run a script which will delete certain data from the table and show the remaining details.

Kindly suggest a way of how to achieve this.

解决方案

If you're using only MS Access, i'd suggest to read this: Use parameters to ask for input when running a query[^].

PARAMETERES [password] char;
DELETE *
FROM TableName
WHERE [password] = 'password'

这篇关于输入特定密码时从msaccess删除数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！