将报告保存为访问表中的图像 [英] Saving Report as Image in Access Table
问题描述
我正在建立锁定商店软件，以便在大学人员获得钥匙时接受电子签名。目前生成该人签名的纸质报告。然后在返回密钥时提交签名的文件。问题是随着时间的推移，文书工作会丢失，破坏或放错地方，所以我们没有任何证据证明雇员必须得到一份他们必须归还的钥匙。
虽然我还没有这样做，但我相信我可以使用给定的密钥和数字签名信息生成一个表格。问题是这种方法不好，因为表中的数据可以在应用程序之外修改，所以我不能使用数据来证明密钥已签名。
我想做的是生成我的基本报告，捕获数字签名，使用嵌入的数字签名重新创建报告，然后允许打印并保存报告作为一个图像我可以放入一个文件，其他一些数据，所以我可以查看图像。
关于如何做到这一点的任何想法？
I am building lock shop software to accept an electronic signature when university personnel are given keys. Currently a paper report is generated that the person signs. The signed paper is then filed for when the keys are returned. The problem is that over time the paperwork gets lost, destroyed, or misplaced so we have nothing to prove that the employee was given a key they must return.
Although I have not done it yet, I am confident that I can generate a table with the key(s) given and the digital signature information. The problem is that this method is not good since the data in a table could be modified outside the application so I can not use the data to prove that the key(s) were signed for.
What I would like to do is generate the base report I have, capture the digital signature, recreate the report with the digital signature imbedded and then allow the report to be printed and also saved as an image I can put in a file, with some other data so I can look up the image.
Any ideas on how to do this?
推荐答案
在Access中保存图像或文件通常是通过OLE Object数据类型完成的。如果它是链接文件，这将需要对象的完整路径。如果文件是嵌入式的，那么数据库最终会变得非常大。
如果此签名的数字加密值可以用来代替图像。
Saving images or files in Access is usually done via an OLE Object datatype. This would require the full path to the object if it is a linked file. If the file is embedded the database would eventually get very big.
If there a numerical encryption value for this signature that could be used instead of an image.
虽然我还没有这样做，但我相信我可以生成一个包含给定密钥和数字签名信息的表。问题是这种方法不好，因为表中的数据可以在应用程序之外修改，所以我不能使用数据来证明密钥已签名。
Although I have not done it yet, I am confident that I can generate a table with the key(s) given and the digital signature information. The problem is that this method is not good since the data in a table could be modified outside the application so I can not use the data to prove that the key(s) were signed for.
不确定你的意思。如何在应用程序外更改数据？
Mary
Not sure what you mean by this. How would the data be altered outside the application?
Mary
如果此签名的数字加密值可用于代替图像。
If there a numerical encryption value for this signature that could be used instead of an image.
是的，我将在记录中使用数字加密值。根据您发布的内容和我阅读的内容，我应该将报告的图像保存在Access之外，并且只包括文件位置。我仍然存在设置生成报告图像并保存文件和指向它的Access记录的自动方式的问题。
Yes there is a numerical encryption value that I will be using in the record. From what you posted and what I have read, I should save the image of the report outside of Access and just include the file location. I still have the problem of setting up an automated way of generating the report image and saving the file and the Access record pointing to it.
不确定你的意思。如何在申请表之外更改数据？
Mary
Not sure what you mean by this. How would the data be altered outside the application?
Mary
律师担心有人可以访问提交并更改或删除数据库中的密钥号码，这样他们就不必返回，或者不知道已知。有一些钥匙。他们认为，如果我们保存报告的图像就会更难以篡改。
The lawyers are worried that someone can gain access to the file and change or remove key numbers in the database so they don''t have to return, or are not "known" to have some keys. They fell that if we save the image of the report it will be much harder to tamper with.
是的，有一个数字加密值我将在记录中使用。根据您发布的内容和我阅读的内容，我应该将报告的图像保存在Access之外，并且只包括文件位置。我仍然存在设置生成报告图像并保存文件和指向它的访问记录的自动方式的问题。
律师担心有人可以访问该文件并更改或删除数据库中的键号，以便它们不必返回，或者不是已知的。有一些钥匙。他们认为，如果我们保存报告的图像，就会更加难以篡改。
Yes there is a numerical encryption value that I will be using in the record. From what you posted and what I have read, I should save the image of the report outside of Access and just include the file location. I still have the problem of setting up an automated way of generating the report image and saving the file and the Access record pointing to it.
The lawyers are worried that someone can gain access to the file and change or remove key numbers in the database so they don''t have to return, or are not "known" to have some keys. They fell that if we save the image of the report it will be much harder to tamper with.
但是如果将图像保存为可访问网络上的文件，这不会使它们更容易被篡改。我要把其他一些专家的注意力转移到这个可能还有其他想法的主题上。
Mary
But if the images are saved as files on an accessible network wouldn''t this make them easier to tamper with. I''m going to drag the attention of some other experts to this thread who may have some other ideas.
Mary
这篇关于将报告保存为访问表中的图像的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
