Vista的MS Access 2000数据库问题 [英] MS Access 2000 Database Problem with Vista
问题描述
您好 -
这是我第一次发布这个群组，所以请耐心等待。还要注意，虽然我很聪明，但数据库并不在我的知识领域。
我正在和一家小型豪华轿车公司合作。他们目前有大约4台联网计算机，都运行Windows XP（w / SP2）和Microsoft Office 2000（特别是Access 2000） - 还有一台普通的jane p3服务器，它还运行Windows XP（w / sp2），并加载了Office 2000。
这些联网计算机正在从上述服务器以多用户方式访问Access 2000 .mdb文件（多于一个用户在任何给定时间访问此共享文件） 。这个文件是他们的客户数据库，用于运行他们的业务。
应该注意的是，这个客户必须使用Access 2000，因为使用Access XP（2002？）如上导致数据库做奇怪的事情，比如创建空白记录，或输入非连续的记录。有一次，Access数据库大师告诉我为什么Access XP（2002）会这样做，但我不记得细节 - 再加上它是在不久前。
前进 -
这家公司最近购买了4台新的戴尔E520（双核P4），并预装了新的可爱（傻笑）Windows Vista 32位商务操作系统。
我已经安装了这4个新的Dell E520系统，并将它们与上述服务器联网。所有正常的东西都在工作，互联网等等。
然后我安装（不要笑或开玩笑）Office 2000，只是为了检查一下。
现在 - 他们不再能够以多用户方式启动Access数据库文件（它位于上述服务器上）。
示例：如果一个用户打开文件，则没有其他联网用户可以在服务器上打开该文件。当第二个或后续用户双击Alias以启动数据库文件时，Vista的小蓝环会绕过几次，但什么都没发生。
如果用户1退出文件，则下一个后续用户可以打开数据库文件，但下一个后续用户则不能。等等等等。
你对自己的说法 - 好吧 - 把它升级到更新版的Acess吧？ - 即使它有一些问题（如上所述）。
是的 - 我做到了。然后我使用Office XP（2002），Office 2003（w / SP2）以及最后的Office 2007进行安装和测试。
所有产生相同的结果，我无法运行该文件像以前一样在XP环境中使用多用户时尚。
我尝试将msaccess兼容模式设置为Windows XP SP2和Windows 2000（对于上面的Office应用程序的每个版本） - 仍然没有运气。
我尝试在管理模式下运行msaccess（在所有上述版本中） - 没有运气
我试过管理模式&以上兼容模式选项在一起 - 没有运气。
我尝试使用Access 2003转换工具将访问2000 .mdb数据库文件更新为Access 2003格式，并尝试再次执行上述所有测试例程 - 即使使用Office 2007 - 仍然没有多用户支持。
此时 - 我无法让这个工作，所以我来这里寻求指导，答案，帮助等等。
任何人都可以提供一些输入，说明为什么我无法在Vista下以多用户方式运行此文件和（选择您的Office版本），因为我以前能够做到XP环境？
非常感谢任何帮助。
谢谢
Leonard
Hello -
This is my first posting to this group, so please bear with me. Also note, that while I''m intelligent, databases are not in my field of knowledge.
I''m working with a small limousine company. They presently have about 4 networked computers, all running Windows XP (w/SP2) and Microsoft Office 2000 (specifically Access 2000) - and a plain jane p3 server also running Windows XP (w/sp2) with Office 2000 loaded onto it.
These networked computers are accessing an Access 2000 .mdb file, in a multi-user fashion (more then one user is accessing this shared file at any given time) from the above mentioned server. This file is their customer database, used to run their business.
It should be noted, that this customers MUST use Access 2000, as using Access XP (2002 ?) as above causes the database to do weird things, such as create blank records, or input records that are non ?contiguous. At one time, an Access database guru told me why Access XP (2002) does this, but I cannot recall the details - plus it was some time ago.
Moving forward -
This company recently purchased 4 new Dell E520''s (Dual Core P4''s) with the new lovely (smirk) Windows Vista 32 bit Business OS preinstalled on them.
I have installed these 4 new Dell E520 systems and networked them with the above mentioned server. All the normal stuff is working, Internet , etc etc.
I then installed (don''t laugh or joke) Office 2000, just to check things out.
Now - they are no longer able to launch the Access database file (that lives on the above mentioned server), in a multi-user fashion any longer.
Example: if one user opens the file, no other networked users can open the file on the server. When the second or subsequent user double clicks the Alias to launch the database file, Vista''s little blue ring goes around a few times, but nothing ever happens.
if user one exits the file, then the next subsequent user can then open the database file, but the next subsequent user cannot. so on and so forth.
Your saying to yourself - well duh - upgrade it to a newer version of Acess right? - even though it has some issues (as identified above).
Yes - I did that. I then installed and tested with Office XP (2002), Office 2003 (w/SP2), and lastly, Office 2007.
All yielded the same results, I cannot run the file in a muli-users fashion, as before in the XP environment.
I tried setting the msaccess compatibility mode to both Windows XP SP2 and Windows 2000 (for each verion of the Office apps above) - still no luck.
I tried seeting msaccess to run in Admin mode (on all above versions) - no luck
I tried Admin mode & the above compatibility mode options together - no luck.
I tried updating the access 2000 .mdb database file to the Access 2003 format using the Access 2003 conversion tool, and attempted to perform all the above testing routine again - even with Office 2007 - Still no multi-user support.
At this point - I''m at a loss to get this to work, so I have come here seeking guidance, answers, help, etc etc.
Can anyone offer me some input as to why I''m unable to run this file in a multi-user fashion under Vista and (pick your version of Office), as I used to be able to do in the XP enviroment ?
Any assistance would be greatly appreciated.
Thanks
Leonard
推荐答案
嗨伦纳德
Open Access。转到工具 - 选项，然后将默认打开模式设置为共享。当您重新安装Access时，它可能会重置为Exclusive。还要确保默认记录锁定设置为编辑记录。
Mary
Hi Leonard
Open Access. Go to Tools - Options and set the Default Open Mode to Shared. When you reinstalled Access it probably reset to Exclusive. Also make sure that the Default Record Locking is set to Edited Record.
Mary
嗨Leonard
Open Access。转到工具 - 选项，然后将默认打开模式设置为共享。当您重新安装Access时，它可能会重置为Exclusive。还要确保默认记录锁定设置为编辑记录。
Mary
Hi Leonard
Open Access. Go to Tools - Options and set the Default Open Mode to Shared. When you reinstalled Access it probably reset to Exclusive. Also make sure that the Default Record Locking is set to Edited Record.
Mary
你好玛丽 -
我按照你的指示检查了设置。它已经设置为Shared，我对编辑记录进行了更改。它似乎没有帮助 - 一次只有1个用户可以访问mdb文件....
还有其他想法吗？
Hi Mary -
I checked the settings as you pointed out. It was already set to Shared, and I made the change to Edited Record. It does not seem to help - only 1 user can access the mdb file at a time....
Any other ideas ?
你好伦纳德
我们还有其他几个类似问题的海报。其中一人通过删除IE7解决了他们的问题。然后发现了这一点。
http：//windowsxp.mvps .org / networkfile.htm
似乎IE7和Vista可能将mde'视为可执行文件。无论如何，看看这是否有助于解决您的问题。
Mary
Hi Leonard
We have had a couple of other posters on with similar issues. One of whom solved their problem initally by removing IE7. The then discovered this.
http://windowsxp.mvps.org/networkfile.htm
It seems IE7 and probably Vista are treating mde''s as executable files. Anyway see if this helps to resolve your problem.
Mary
这篇关于Vista的MS Access 2000数据库问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
