I'm trying to fix and add some functionality to an Access Database that a group I work with uses. They have a FileName.accdb file which holds the queries and forms. The data seems to be stored in one of two other database files FileName_be.accdb and/or FileName_bp.accdb both stored in a 'Back End' Folder beside the FileName.accdb file.
我正在试图修复并添加一些功能到我使用的组的访问数据库中。他们有一个文件名。包含查询和表单的accdb文件。数据似乎存储在另外两个数据库文件FileName_be中的一个中。accdb和/或FileName_bp。accdb都存储在文件名旁边的“后端”文件夹中。accdb文件。
I was hoping someone might be able to explain how all this might link together, there is no documentation on how it was organized.
我希望有人能够解释这一切如何联系在一起，没有关于它是如何组织的文档。
The other thing that seems odd to me is that 3 files are similar in size:
另一件让我觉得奇怪的事是，3个文件大小相似:
FileName.accdb = 11MB
文件名。accdb = 11 mb
FileName_be.accdb = 10.1MB
FileName_be。accdb = 10.1 mb
FileName_bp.accdb file = 7.5MB
FileName_bp。accdb文件= 7.5 mb
The _bp and _be files both only have the database tables, but the _bp file seems to be more up to date.
_bp和_be文件都只有数据库表，但是_bp文件似乎更及时。
1 个解决方案
#1
2
Your database is split into Frontend and Backend. See e.g.
Microsoft Access Split Database Architecture.
您的数据库分为前端和后端。参见Microsoft Access Split Database Architecture。
FileName.accdb should have linked tables, queries, forms and code.
文件名。accdb应该有链接的表、查询、表单和代码。
FileName_be.accdb sounds like a backend, having only tables.
FileName_be。accdb听起来像后端，只有表。
FileName_bp.accdb - if it's newer, maybe "bp" is "backend production", but that's just a guess.
FileName_bp。accdb——如果是新的，也许“bp”就是“后端生产”，但这只是猜测。
Open FileName.accdb and open a linked table in design view. In the property sheet, the Description will tell you where the table is linked from. The tooltip in the navigation bar will do so too.
打开文件名。在设计视图中打开一个连接表。在属性表中，描述将告诉您表从何处链接。导航栏中的工具提示也会这样做。
Alternatively, you can use External Data -> Linked Table Manager to re-map these file locations.
或者，您可以使用外部数据->链接表管理器重新映射这些文件位置。
#1
2
Your database is split into Frontend and Backend. See e.g.
Microsoft Access Split Database Architecture.
您的数据库分为前端和后端。参见Microsoft Access Split Database Architecture。
FileName.accdb should have linked tables, queries, forms and code.
文件名。accdb应该有链接的表、查询、表单和代码。
FileName_be.accdb sounds like a backend, having only tables.
FileName_be。accdb听起来像后端，只有表。
FileName_bp.accdb - if it's newer, maybe "bp" is "backend production", but that's just a guess.
FileName_bp。accdb——如果是新的，也许“bp”就是“后端生产”，但这只是猜测。
Open FileName.accdb and open a linked table in design view. In the property sheet, the Description will tell you where the table is linked from. The tooltip in the navigation bar will do so too.
打开文件名。在设计视图中打开一个连接表。在属性表中，描述将告诉您表从何处链接。导航栏中的工具提示也会这样做。
Alternatively, you can use External Data -> Linked Table Manager to re-map these file locations.
或者，您可以使用外部数据->链接表管理器重新映射这些文件位置。