渴望重建数据库和程序!! [英] Desire to REMERGE Database and Program!!

问题描述

嗨：


前段时间我在Access中开发了一个程序，并将数据库和程序分开了

本身（使用普通的访问工具）我们在我们的服务器上安装了数据库，并且在桌面系统上安装了数据库。我已经多次修改了程序，现在发现我需要

来改变数据库的轻微。这似乎要求我重新获得数据库和

程序，我不知道该怎么做。


有人可以给我一些指示，因为帮助包对此没有帮助！


问候


John Baker

Hi:

Some time ago I developed a program in Access, and separated the database and the program
itself (using the normal access tools).We have the db on our server and the programin the
desktop system. I have modified the program a number of times, and now find that I need
to change the DB slightlt. This appears to require that I REMERGE the data base and
program, and I have no idea how to do that.

Can someone give me some pointers, since the help package is of NO help with this!

Regards

John Baker

推荐答案

2003年11月12日星期三格林尼治标准时间16:04:12，John Baker< Ba ****** @ Verizon.net>

在comp.databases.ms中写道 - 访问：

On Wed, 12 Nov 2003 16:04:12 GMT, John Baker <Ba******@Verizon.net>
wrote in comp.databases.ms-access:

前段时间我在Access中开发了一个程序，并将数据库和程序分开（本身）正常的访问工具）。我们的服务器上有数据库，而且桌面系统是programin。


对你有好处。

我已多次修改程序，现在发现我需要
更改数据库轻微。


这并不奇怪。

这似乎要求我重新启动数据库和
程序，我不知道如何要做到这一点。


否 - 它不需要这样的东西。

有人可以给我一些指示，因为帮助包对此没有帮助！

Some time ago I developed a program in Access, and separated the database and the program
itself (using the normal access tools).We have the db on our server and the programin the
desktop system.
Good for you.
I have modified the program a number of times, and now find that I need
to change the DB slightlt.
This is not at all unusual.
This appears to require that I REMERGE the data base and
program, and I have no idea how to do that.
No - it requires no such thing.
Can someone give me some pointers, since the help package is of NO help with this!

帮助包对此没有任何帮助，因为没有充分的理由

需要这样的东西。为什么你认为你必须重新记录文件，失去单独的fe / be部署的好处，

并违背开发人员的好建议和Msft分裂

应用程序和数据文件 - 你已经好了建议

跟着？

Peter Miller

__________________________________________________ __________

PK解决方案 - Microsoft Access / Jet / SQL数据恢复

免费报价，保证最低价格和最佳结果
www.pksolutions.com 1.866.FILE.FIX 1.760.476.9051

The ''help package'' has no help on this because there is no good reason
for such a thing to be required. Why exactly do you believe you must
remerge the files, losing the benefits of separate fe/be deployment,
and going against the good advice of developers and Msft to split
application and data files - good advice that you have already
followed?
Peter Miller
__________________________________________________ __________
PK Solutions -- Data Recovery for Microsoft Access/Jet/SQL
Free quotes, Guaranteed lowest prices and best results
www.pksolutions.com 1.866.FILE.FIX 1.760.476.9051

John，

为什么需要重新合并程序？我想不出你为什么需要

的原因。

这样做的简单方法就是清除所有链接

前端的表格，然后从后端导入表格。


Terry

" John Baker" <巴****** @ Verizon.net>在留言中写道

news：0e ******************************** @ 4ax.com ...

John,
Why would you need to re-merge the program? I can''t think of any reason why
you would need to.

The straightforward way to do it though would be to clear all the linked
tables in the front end and then import the tables from the back end.

Terry
"John Baker" <Ba******@Verizon.net> wrote in message
news:0e********************************@4ax.com...

嗨：

前段时间我在Access中开发了一个程序，并将数据库
与程序本身分开（使用普通访问工具）我们的服务器上有db，桌面系统上有
programin。我已多次修改程序，现在
发现我需要更改数据库轻微。这似乎要求我重新获得数据
基础和程序，我不知道该怎么做。

有人可以给我一些指示，因为帮助包没有帮助
这个！
问候

John Baker

Hi:

Some time ago I developed a program in Access, and separated the database and the program itself (using the normal access tools).We have the db on our server and the programin the desktop system. I have modified the program a number of times, and now find that I need to change the DB slightlt. This appears to require that I REMERGE the data base and program, and I have no idea how to do that.

Can someone give me some pointers, since the help package is of NO help with this!
Regards

John Baker

John，

我认为你说的是​​你将数据库分成前端

（表格，查询，报告）和后端（表格），现在想要返回

表到当前后端。


首先制作后端的备份副本。


打开前端数据库（使用表格，查询等。）

删除链接表（链接表旁边会有一个箭头

显示它们已链接）。如果没有箭头，那么该表位于前端

，不应删除。

别担心，你不是要删除后端，只是前后两端之间的链接

。


删除链接表后，单击文件+获取外部数据+导入

按照向导，从后端导入表格定义和数据，以及

关系。


这应该是你的全部需要。

确保关系正确。


前一个后端仍包含原始表和数据。

前前端现在包含所有内容，不再链接到

旧后端。

-

Fred


请回复此新闻组。

我不回复个人电子邮件。

" John Baker" <巴****** @ Verizon.net>在留言中写道

news：0e ******************************** @ 4ax.com ...

John,
I think what your saying is that you split the database into a Front end
(forms, queries, reports) and a Back end (tables) and now want to return the
tables to the current back end.

Make a Back Up copy of the Back end first.

Open the Front end database (with the Forms, Queries, etc.).
Delete the linked tables (the linked tables will have an arrow next to them
showing they are linked). If there is no arrow, then that table resides on
the Front end and should NOT be deleted.
Don''t worry, you are not deleting the tables in the Back end, just the links
between the Front and Back ends.

Once the linked tables are deleted, click File + Get External Data + Import
Follow the wizard and import the tables definition and data, and
relationships, from the Back end.

That should be all you need.
Make sure the relationships are correct.

The former Back end still contains the original tables and data.
The former Front end now contains everything and is no longer linked to the
old Back end.
--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.
"John Baker" <Ba******@Verizon.net> wrote in message
news:0e********************************@4ax.com...

嗨：

前段时间我在Access中开发了一个程序，并将数据库
与程序本身分开（使用普通访问工具）我们的服务器上有db，桌面系统上有
programin。我已多次修改程序，现在
发现我需要更改数据库轻微。这似乎要求我重新获得数据
基础和程序，我不知道该怎么做。

有人可以给我一些指示，因为帮助包没有帮助
这个！
问候

John Baker

Hi:

Some time ago I developed a program in Access, and separated the database and the program itself (using the normal access tools).We have the db on our server and the programin the desktop system. I have modified the program a number of times, and now find that I need to change the DB slightlt. This appears to require that I REMERGE the data base and program, and I have no idea how to do that.

Can someone give me some pointers, since the help package is of NO help with this!
Regards

John Baker

这篇关于渴望重建数据库和程序!!的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！