运行拆分向导时表关系丢失。为什么？ [英] Table relationships lost when ran splitting wizard. WHY?

问题描述

我正在运行Access 2002，只是运行了内置的Access向导，用于

将数据库拆分为后端（带表）和前端（带

查询，形式，模块等）。


运行向导后，我打开了表关系视图，发现

缺少所有关系。这应该发生吗？如果是这样，

为什么？我已经注意到查询现在表现得很奇怪，因为关系没有建立，因此看起来好像是b $ b。


我应该进入后端数据库并重新建立

关系？或者，我应该在前端数据库中这样做。


这种行为看起来很奇怪。这是Access 2002的错误吗？


感谢您的帮助！


Ed

I am running Access 2002 and just ran the built in Access wizard for
splitting a database into a back end (with tables) and front end (with
queries, forms, modules, etc.).

After running the wizard, I opened the table relationship view and noticed
that all the relationships are missing. Is this supposed to happen? If so,
why? I''ve noticed that queries are behaving strangely now, seemingly
because the relationships are not established.

Am I supposed to go into the back end database and reestablish the
relationships? Or, am I supposed to do that in the front end database.

This behavior seems odd. Is this an Access 2002 bug?

Thank you for your help!

Ed

推荐答案

" Ed" <一个******* @ discussions.com>写道：

"Ed" <an*******@discussions.com> wrote:

我正在运行Access 2002，只是运行了内置的Access向导，以便将数据库拆分为后端（带表格）和前端（带有查询，表单，模块等）。

运行向导后，我打开了表关系视图，发现所有关系都丢失了。这应该发生吗？如果是这样，为什么？


它不应该，但我从未使用过分裂向导。我会进入BE并且

看看关系视图是否仍然存在。您可能需要单击工具栏上的显示所有

按钮。


如果缺少布局，请使用
www.trigeminal.com 复制关系窗口布局。

如果关系确实不在后端，您仍然可以使用sysrels

实用程序来复制关系窗口布局。你必须自己拖放

关系，但这样做的工作会少一些。

我注意到现在的查询表现得很奇怪，貌似
因为没有建立关系。


告诉我们更多信息。

我是否应该进入后端数据库并重新建立
关系？或者，我是否应该在前端数据库中执行此操作。

I am running Access 2002 and just ran the built in Access wizard for
splitting a database into a back end (with tables) and front end (with
queries, forms, modules, etc.).

After running the wizard, I opened the table relationship view and noticed
that all the relationships are missing. Is this supposed to happen? If so,
why?
It shouldn''t but then I''ve never used the splitting wizard. I''d go into the BE and
see if the relationship view is still there. You may need to click on the Show All
button on the tool bar.

If the layout is missing then use the appropriate sysrels tool from
www.trigeminal.com to copy the relationships window layout.

And if the relationships are not indeed in the backend you can still use the sysrels
utility to copy the relationships window layout. You''ll have to drag and drop the
relationships yourself but that''ll be less work.
I''ve noticed that queries are behaving strangely now, seemingly
because the relationships are not established.
Tell us more.
Am I supposed to go into the back end database and reestablish the
relationships? Or, am I supposed to do that in the front end database.

否，始终在表所在的MDB中创建关系。
<
Tony

-

Tony Toews，Microsoft Access MVP

请仅在新闻组中回复，以便其他人可以

阅读整个消息主题。

Microsoft Access Links，Hints，Tips&会计系统
http://www.granite.ab.ca /accsmstr.htm

Tony Toews写道：

Tony Toews wrote:

" Ed" <一个******* @ discussions.com>写道：

"Ed" <an*******@discussions.com> wrote:

我正在运行Access 2002，只是运行了内置的Access向导，以便将数据库拆分为后端（带表格）和前端（带有查询，表单，模块等）。

运行向导后，我打开了表关系视图，发现所有关系都丢失了。这应该发生吗？如果是这样，
为什么？

I am running Access 2002 and just ran the built in Access wizard for
splitting a database into a back end (with tables) and front end (with
queries, forms, modules, etc.).

After running the wizard, I opened the table relationship view and noticed
that all the relationships are missing. Is this supposed to happen? If so,
why?

它不应该，但我从来没有使用过分裂向导。我会进入BE并查看关系视图是否仍然存在。您可能需要单击工具栏上的Show All
按钮。

如果缺少布局，请使用
www.trigeminal.com 复制关系窗口布局。

如果关系不确实在后端，您仍然可以使用sysrels
实用程序来复制关系窗口布局。你必须自己拖放
关系，但这样做的工作会少一些。

It shouldn''t but then I''ve never used the splitting wizard. I''d go into the BE and
see if the relationship view is still there. You may need to click on the Show All
button on the tool bar.

If the layout is missing then use the appropriate sysrels tool from
www.trigeminal.com to copy the relationships window layout.

And if the relationships are not indeed in the backend you can still use the sysrels
utility to copy the relationships window layout. You''ll have to drag and drop the
relationships yourself but that''ll be less work.

Tony，我在一个应用程序中设置了我之间的关系访问了关系窗口

以后窗口里面有无数的桌子，在

的地方纵横交错。它看起来像西方意大利面。这是正常的，因为你定义一个应用程序

并构建和扩展它？

Tony, in one app I did I set my relationships in I visited the relationships window
later on and the window had myriads of tables in it, lines crisscrossing all over the
place. It looked like a spaghetti western. Is that normal as you define an application
and build and expand it?

Salad< oi*@vinegar.com>写道：

Salad <oi*@vinegar.com> wrote:

托尼，在我做的一个应用程序中，我设置了我的关系，我之后访问了人际关系窗口，窗口里面有无数的桌子，所有的线条都交叉着在
的地方。它看起来像西方意大利面。你定义一个应用程序并构建和扩展它是正常的吗？

Tony, in one app I did I set my relationships in I visited the relationships window
later on and the window had myriads of tables in it, lines crisscrossing all over the
place. It looked like a spaghetti western. Is that normal as you define an application
and build and expand it?

No.或者我的一些确实看起来像意大利面条然后我

设计了这种布局。 <微笑>我的其中一个在48英寸的b $ b绘图仪上打印并且需要三英尺的纸张。


当我将BE导入新的BE时，我发生了这种情况。

表放在一个网格上，并且这些线在

处运行。


但这是sysrels实用程序进来。它将复制旧的

关系窗口布局。


Tony


-

Tony Toews，Microsoft Access MVP

请仅在新闻组中回复，以便其他人可以

阅读整个消息主题。

Microsoft Access Links，Hints，Tips&会计系统
http://www.granite.ab.ca /accsmstr.htm

这篇关于运行拆分向导时表关系丢失。为什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！