Microsoft Access，拆分错误 [英] Microsoft Access, Splitting Error

问题描述

我正在实现我的第一个Access数据库.我已经阅读了许多指南/手册，而且我相信我已经快要完成了. Access数据库将由3-4个用户使用.

I'm implementing my first Access Database. I've read numerous guides/manuals, and I believe I'm nearly at the finish line. The Access Database will be used by 3-4 users.

我有三个表，所有这些表都是到三个不同Excel文件的实时"连接.这些Excel文件位于共享驱动器上，这些共享文件将由不同的用户定期更新.

I have three tables, all of which are "live" connections to three different Excel file. These Excel files are on a shared drive, which are to be updated periodically by the different users.

我有一个使用每个不同表的查询(3).

I have a single query that uses each of the different tables (3).

目标是使用户能够查看查询的输出.据我了解，构造Access的最佳方法是拆分数据库.我希望将这三个表存储在后端"数据库中，并将查询存储在前端"数据库中.

The goal is to give the users the ability to view the output of the query. From my understanding, the best way to structure Access is to split the database. I'd like the three tables to be stored in the "Back-End" database, and the Query to be on the "Front-End" database.

我遇到的问题是，在使用数据库拆分器"时，出现错误此数据库中没有表.后端数据库将为空".我已经搜索了过去几个小时，但似乎找不到该错误的原因.我相信很明显我确实有桌子.我想念什么?任何意见/建议都将不胜感激！

The issue that I'm running into is that, when using the "Database Splitter", I'm given the error "There are no tables in this database. The back-end database will be empty". I've searched for the past couple hours, but I can't seem to find a reason for this error. I believe it is quite clear that I do indeed have tables. What am I missing? Any input/suggestions are greatly appreciated!

推荐答案

当数据库中有表和前端内容时，可以使用数据库拆分器".然后，拆分器"将创建一个附加的Access数据库，将表移动"到新数据库，并在旧数据库中创建链接表，这些链接表映射新数据库中的表.您已经有链接表，因此无需拆分(您的链接表甚至都不是Access表).

The "Database Splitter" can be used when you have tables and front-end things in your database. The "Splitter" would then create an additional Access database, "move" the tables to the new database and create linked tables in the old database that map the the tables in the new database. You already have linked tables, so there's nothing to split (your linked tables are not even Access tables).

这篇关于Microsoft Access，拆分错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！