我可以向加密的Access 2010数据库中添加一些公共元数据吗? [英] Can I add some public meta data to an encrypted Access 2010 database?

问题描述

我的应用程序将其数据存储在Access 2010数据库(accdb)文件中.它受密码保护，这意味着它已使用AES-128加密.

My application stores its data in an Access 2010 database (accdb) file. It's password protected, which means it's encrypted w/ AES-128.

我想向公共可用文件中添加一些元数据.这样，我的应用程序的较早版本就可以调查文件，看是否值得尝试打开.否则，他们只会得到可怕的无法识别的数据库格式"错误，该错误通常与文件损坏有关.

I'd like to add some meta data to the file that's publically available. This way older verisons of my application can investigate the file to see if it's even worth trying to open. Otherwise, they'll just get the dreaded "Unrecognized Database Format" error, which is usually associated with file corruptions.

在Windows中，可以右键单击文件，单击属性"，然后在详细信息"选项卡下查看属性.如果我添加属性，例如上次接触文件的应用程序版本，以及其他详细信息，我将非常喜欢.我希望避免为每个版本的应用使用不同的文件扩展名！

In Windows, you can right-click on a file, click "Properties" and see attributes under the Details tab. I'd love it if I add attributes like the version of my application that last touched the file, and maybe other details. I'd like to avoid having a different file extension for each version of my app!

是否可以向加密的Access 2010数据库中添加一些公共元数据?

Is it possible to add some public meta data to an encrypted Access 2010 database?

推荐答案

这是一个难以克服的难题！应用程序必须读取有关ACCDB的信息，但是该信息不能存储在ACCDB中，因为您希望在不打开ACCDB的情况下进行读取.而且您不能使用建议的文件系统方法，因为它必须在Mac上的Wine上可以正常工作(我假设您还有另一个问题).

This is a tough nut to crack! An application must read information about the ACCDB, but that information can't be stored in the ACCDB because you want the read without opening the ACCDB. And you can't use the suggested file system methods because this must work under Wine on Mac (I assume from another of your questions).

我看到的唯一解决方案是创建一个伴随文件(具有相同的基本名称，但扩展名不同)来保存元数据.因此，如果您的应用程序想了解SomeDb.accdb，它将寻找一个名为SomeDb.metadata的文件并读取该文件.

The only solution I can see is to create a companion file (with same base name but different extension) to hold the metadata. So if your application wants to know about SomeDb.accdb, it would look for a file named SomeDb.metadata and read that instead.

我建议您为之前的问题打个电话……很不幸，这是另一个问题. :-)但是，这很简单，即使在Mac上，它也应该起作用.

I suggested a kludge for your earlier question ... unfortunately this is another. :-) However, it's a simple kludge and it should work ... even on Mac.

这篇关于我可以向加密的Access 2010数据库中添加一些公共元数据吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！