Access 97和Access 2000/2003之间的差异 [英] Differences between Access 97 and Access 2000/2003

问题描述

大家好，


我们公司正在从Windows NT迁移到XP，并且正在从

Access 97迁移到Access 2003.

由于分阶段推出，我们面临的情况是，一些用户仍然在NT上，而其他用户已完全升级，但所有用户都需要使用

相同的Access数据库。

起初我们尝试用XP打开Access 97数据库，但我们担心，一些不那么懂电脑的员工可能会点击 ;是" on

你想把这个数据库转换成最新版本吗？提示。

我们提出的解决方案是在XP中创建

数据库的精确副本，但删除所有表并重新链接到97

版本。

这个解决方案总体上运行良好，但是有一些

实例，其中该数据库需要修复。


我们仍然遇到的主要问题是，我和我的同事在没有任何用户的情况下可以更长时间地对数据库进行任何更改。是

这个我们可以更改的设置？

例如，在97上你可以改变实时数据库中的表格然后

保存更改后的表格。 ..... XP似乎不允许你这样做。


任何帮助都会受到大力赞赏。


谢谢提前，


John

Hi All,

Our company is migrating from Windows NT to XP and in the process from
Access 97 to Access 2003.
Due to the phased rollout we are faced with a situation where some users are
still on NT while others have been fully upgraded, but all users need to use
the same Access databases.
At first we tried just opening the Access 97 databases with XP but we were
worried that some of the less computer-literate employees may click "yes" on
the "Do you want to convert this database to the latest version" prompt.
The solution we have come up with is to create an exact duplicate of the
database in XP but with all the Tables removed and relinked to the 97
version.
This solution is working well on the whole but there have been a couple of
instances where that database has required a repair.

The main problem we are still having is that my colleagues and I can no
longer make any changes to the database while there are any users in. Is
this a setting which we can change?
For instance, on 97 you could alter a form in the live database and then
save the altered form......XP doesn''t seem to allow you to do that.

Any help would be massively appreciated.

Thanks in Advance,

John

推荐答案

John，正如您所发现的，Access 2000及更高版本做了一个整体的保存，还有

没有设置要覆盖它。


有关适应新版本的其他建议，请参阅：

从Access 97转换为2000,2002或2003
at：
http://allenbrowne.com/ser -48.html

（整体保存问题在可用性问题下列为＃6。）


-

Allen Browne - 微软MVP。西澳大利亚州珀斯。

访问用户提示 - http：// allenbrowne.com/tips.html

回复群组，而不是mvps dot org的allenbrowne。


" John Ortt" <乔****** @ Idontwantspamsonoreturnaddress.com>在消息中写道

news：42 ********** @ glkas0286.greenlnk.net ...

John, as you found, Access 2000 and later do a monolithic save, and there is
no setting to override this.

For other suggestions on adapting to the newer versions, see:
Converting from Access 97 to 2000, 2002 or 2003
at:
http://allenbrowne.com/ser-48.html
(The monolithic save issue is listed as #6 under ''Usability issues''.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"John Ortt" <Jo******@Idontwantspamsonoreturnaddress.com> wrote in message
news:42**********@glkas0286.greenlnk.net...

我们公司正在迁移Windows NT到XP以及从Access 97到Access 2003的过程。
由于分阶段推出，我们面临着一些用户仍然在NT上的情况其他人已经完全升级，但所有用户都需要使用相同的Access数据库。
起初我们尝试用XP打开Access 97数据库，但我们担心一些不太注重计算机的员工可以点击是，然后单击是否要将此数据库转换为最新版本。提示。
我们提出的解决方案是在XP中创建一个完全相同的数据库，但删除所有表并重新链接到97
版本。
这个解决方案总体上运作良好，但有几个实例，其中数据库需要修复。

我们仍然遇到的主要问题是我的同事和我不能
在有任何用户的情况下对数据库进行更长时间的更改。这是一个我们可以更改的设置吗？
例如，在97上你可以改变实时数据库中的表单然后
保存改变的形式...... XP似乎不允许你这样做。

任何帮助都会受到大力赞赏。
提前致谢，

John

Our company is migrating from Windows NT to XP and in the process from
Access 97 to Access 2003.
Due to the phased rollout we are faced with a situation where some users
are
still on NT while others have been fully upgraded, but all users need to
use
the same Access databases.
At first we tried just opening the Access 97 databases with XP but we were
worried that some of the less computer-literate employees may click "yes"
on
the "Do you want to convert this database to the latest version" prompt.
The solution we have come up with is to create an exact duplicate of the
database in XP but with all the Tables removed and relinked to the 97
version.
This solution is working well on the whole but there have been a couple of
instances where that database has required a repair.

The main problem we are still having is that my colleagues and I can no
longer make any changes to the database while there are any users in. Is
this a setting which we can change?
For instance, on 97 you could alter a form in the live database and then
save the altered form......XP doesn''t seem to allow you to do that.

Any help would be massively appreciated.

Thanks in Advance,

John

谢谢Allen，


没有回答我想但仍然非常有帮助:)

" Allen Browne" <铝********* @ SeeSig.Invalid>在消息中写道

news：42 *********************** @ per-qv1-newsreader-01.iinet.net。 au ...

Thanks Allen,

No the answer I wanted but still very helpful :)
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:42***********************@per-qv1-newsreader-01.iinet.net.au...

John，正如您所发现的，Access 2000及更高版本执行单片保存，并且
没有设置来覆盖此。

对于其他有关适应新版本的建议，请参阅：
从Access 97转换为2000,2002或2003

http://allenbrowne.com/ser-48.html
（整体保存问题在可用性问题下列为＃6 ''。）

-
Allen Browne - 微软MVP。西澳大利亚州珀斯。
访问用户提示 - http://allenbrowne.com/ tips.html
回复群组，而不是mvps dot org的allenbrowne。

John, as you found, Access 2000 and later do a monolithic save, and there is no setting to override this.

For other suggestions on adapting to the newer versions, see:
Converting from Access 97 to 2000, 2002 or 2003
at:
http://allenbrowne.com/ser-48.html
(The monolithic save issue is listed as #6 under ''Usability issues''.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

" John Ortt" ; <乔****** @ Idontwantspamsonoreturnaddress.com>在消息中写道

news：42 ********** @ glkas0286.greenlnk.net ...

"John Ortt" <Jo******@Idontwantspamsonoreturnaddress.com> wrote in message
news:42**********@glkas0286.greenlnk.net...

大家好，


我想知道哪家公司。

由于分阶段推出，我们面临的情况是，一些用户仍然在NT上，而其他用户已经完全升级，但所有用户都需要使用
相同的Access数据库。
起初我们尝试用XP打开Access 97数据库，但我们担心一些不那么懂电脑的员工可能会点击是
br />您要将此数据库转换为最新版本吗？提示。
我们提出的解决方案是在XP中创建一个完全重复的数据库，但删除所有表并重新链接到97
版本。


似乎是合理的。

这个解决方案总体上运行良好但是有几个实例需要修复数据库。


我不确定这是否与A2k3链接到A97 BE有关。
我们仍然遇到的主要问题是我的同事和我不能例如，在97上你可以改变实时数据库中的表单，然后<保存改变的形式...... XP似乎不允许你这样做。

Hi All,

Our company is migrating from Windows NT to XP and in the process from
Access 97 to Access 2003.
I wonder which company that is.
Due to the phased rollout we are faced with a situation where some users
are
still on NT while others have been fully upgraded, but all users need to
use
the same Access databases.
At first we tried just opening the Access 97 databases with XP but we were
worried that some of the less computer-literate employees may click "yes"
on
the "Do you want to convert this database to the latest version" prompt.
The solution we have come up with is to create an exact duplicate of the
database in XP but with all the Tables removed and relinked to the 97
version.
Seems reasonable.
This solution is working well on the whole but there have been a couple of
instances where that database has required a repair.
I''m not sure that is related to A2k3 linking to an A97 BE.
The main problem we are still having is that my colleagues and I can no
longer make any changes to the database while there are any users in. Is
this a setting which we can change?
For instance, on 97 you could alter a form in the live database and then
save the altered form......XP doesn''t seem to allow you to do that.

这是非常危险的做法，更多可能是腐败的根源而不是链接不同版本的
。您永远不应该尝试在

生产环境中更改FE，您应该始终使用开发副本，并且一旦测试完成，就会将其部署到生产中。您还应确保所有用户都拥有自己的FE副本

。这也可以最大程度地降低发生不需要的转换的风险。应用用户级别的安全性

会阻止它的发展，但这是一个更长期的解决方案。


HTH - Keith。
www.keithwilby.com

This is very dangerous practice, far more likely a source of corruption than
linking different versions. You should never attempt to change a FE in the
production environment, you should always work on a development copy and
deploy it to production once testing is complete. You should also ensure
that all users have their own copies of the FE. This would also minimise
the risk of unwanted conversions taking place. Applying user-level security
would stop it in its tracks but is a more long-term solution.

HTH - Keith.
www.keithwilby.com

这篇关于Access 97和Access 2000/2003之间的差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！