网络数据库 [英] networking the db
问题描述
好的 - 我有一个关于将我们的数据库放在网络上的问题。帮助我的人离开了城镇，当他在这里时似乎正在工作，但现在我们遇到了一些问题，所以任何帮助都会非常受欢迎！ :-)
我为多个用户创建了这个数据库。我进入了必须有登录名和密码进入数据库的地方。当我完成后，我把它保存在我们的网络上，但是当其他人去打开数据库时，并没有要求他们输入密码 - 虽然我在计算机上打开它时它正在工作.... />
所以我们做的是我们制作了一个包含以下内容的.BAT文件：
ECHO OFF
START" C：\Program Files \\ \\ Microsoft Office \ Office /\\Macaccess.Exe" " T：\Trades\Database\vioxJOBtrack.mdb" / wrkgrp" T：\ Trades \Database \TRADESGRP.mdw"
然后我们将该文件转换为.exe应用程序文件。在我的计算机上这确实有效 - 所以我打开.exe文件并打开一个dos窗口，找到它需要打开的文件，然后打开数据库并关闭dos窗口。数据库在那里，开放，它很好。
但是当别人正在测试它时 - 他去了网络驱动器，点击.exe文件，dos窗口打开但数据库永远不会打开。然后dos窗口关闭。差不多，它在他的电脑上不起作用。
我试着用最好的方式解释这个 - 我很确定我错过了一些细节，可能......所以如果你有任何问题请告诉我!!
关于问题可能是什么的任何想法。
谢谢!!
Ok-I have a question about putting our database out on the network. The guy that was helping me with this went out of town and it seemed to be working when he was here but now we are having some issues so any help would be SO MUCH APPRECIATED! :-)
Well I created this db for a multiple users. I made it to where you have to have a login name and password to get into the db. When I was finished I saved it out on our network, but when other people went to open the db it was not asking them for a password to get in-although it was working when I opened it on my computer....
So what we did was we made a .BAT file that included the following:
ECHO OFF
START "C:\Program Files\Microsoft Office\Office\Msaccess.Exe" "T:\Trades\Database\vioxJOBtrack.mdb" /wrkgrp "T:\Trades\Database\TRADESGRP.mdw"
Then we made that file into an .exe application file. On my computer this does work - so I open the .exe file and it opens a dos window, locates the file it needs to be opening, then the database opens and the dos window closes. And the db is there, open, its good to go.
BUT when someone else was testing it - he went to the network drive, clicks on the .exe file, the dos window opens but the db never opens. Then the dos window closes. So pretty much, it doesnt work on his computer.
I tried explaining this the best I could-I''m sure I missed some details, possibly...so just let me know if you have any questions!!
Any ideas on what the problem could be.
THANKS!!
推荐答案
好的 - 我有一个关于将我们的数据库放在网络上的问题。帮助我的人离开了城镇，当他在这里时似乎正在工作，但现在我们遇到了一些问题，所以任何帮助都会非常受欢迎！ :-)
我为多个用户创建了这个数据库。我进入了必须有登录名和密码进入数据库的地方。当我完成后，我把它保存在我们的网络上，但是当其他人去打开数据库时，并没有要求他们输入密码 - 虽然我在计算机上打开它时它正在工作.... />
所以我们做的是我们制作了一个包含以下内容的.BAT文件：
ECHO OFF
START" C：\Program Files \\ \\ Microsoft Office \ Office /\\Macaccess.Exe" " T：\Trades\Database\vioxJOBtrack.mdb" / wrkgrp" T：\ Trades \Database \TRADESGRP.mdw"
然后我们将该文件转换为.exe应用程序文件。在我的计算机上这确实有效 - 所以我打开.exe文件并打开一个dos窗口，找到它需要打开的文件，然后打开数据库并关闭dos窗口。数据库在那里，开放，它很好。
但是当别人正在测试它时 - 他去了网络驱动器，点击.exe文件，dos窗口打开但数据库永远不会打开。然后dos窗口关闭。差不多，它在他的电脑上不起作用。
我试着用最好的方式解释这个 - 我很确定我错过了一些细节，可能......所以如果你有任何问题请告诉我!!
关于问题可能的任何想法。
谢谢!!
Ok-I have a question about putting our database out on the network. The guy that was helping me with this went out of town and it seemed to be working when he was here but now we are having some issues so any help would be SO MUCH APPRECIATED! :-)
Well I created this db for a multiple users. I made it to where you have to have a login name and password to get into the db. When I was finished I saved it out on our network, but when other people went to open the db it was not asking them for a password to get in-although it was working when I opened it on my computer....
So what we did was we made a .BAT file that included the following:
ECHO OFF
START "C:\Program Files\Microsoft Office\Office\Msaccess.Exe" "T:\Trades\Database\vioxJOBtrack.mdb" /wrkgrp "T:\Trades\Database\TRADESGRP.mdw"
Then we made that file into an .exe application file. On my computer this does work - so I open the .exe file and it opens a dos window, locates the file it needs to be opening, then the database opens and the dos window closes. And the db is there, open, its good to go.
BUT when someone else was testing it - he went to the network drive, clicks on the .exe file, the dos window opens but the db never opens. Then the dos window closes. So pretty much, it doesnt work on his computer.
I tried explaining this the best I could-I''m sure I missed some details, possibly...so just let me know if you have any questions!!
Any ideas on what the problem could be.
THANKS!!
听起来好像忘了在另一台计算机上映射网络驱动器。转到Windows资源管理器并在该共享目录中的每台计算机上选择工具>映射网络驱动器。
Sounds to me like you forgot to map the network drive on the other computer. Go to Windows Explorer and select Tools>Map Network Drive on each computer that is to be in that shared directory.
听起来像我一样您忘记在另一台计算机上映射网络驱动器。转到Windows资源管理器，然后在该共享目录中的每台计算机上选择工具>映射网络驱动器。
Sounds to me like you forgot to map the network drive on the other computer. Go to Windows Explorer and select Tools>Map Network Drive on each computer that is to be in that shared directory.
我检查了我的驱动器是如何映射的，然后检查另一台计算机以查看该驱动器的映射方式，两者都是相同的。数据库在共享网络上（在我们的例子中它位于T：\\驱动器上）所以我检查了我的T：\\驱动器是如何映射的以及它是如何映射的，两者都是相同。
还有其他选择吗？
谢谢！
Well I checked how my drive is mapped and then checked the other computer to see how that drive is mapped and both are the same. The db is out on a shared network( in our case it is on the T:\\ drive) So I checked how my T:\\ drive is mapped and how thier''s is mapped and both are the same.
Any other options??
THANKS!
我检查了我的驱动器是如何映射的，然后检查另一台计算机以查看该驱动器的映射方式，两者都是相同的。数据库在共享网络上（在我们的例子中它位于T：\\驱动器上）所以我检查了我的T：\\驱动器是如何映射的以及它是如何映射的，两者都是相同。
还有其他选择吗？
感谢！
Well I checked how my drive is mapped and then checked the other computer to see how that drive is mapped and both are the same. The db is out on a shared network( in our case it is on the T:\\ drive) So I checked how my T:\\ drive is mapped and how thier''s is mapped and both are the same.
Any other options??
THANKS!
1.确认访问共享目录的用户对该目录具有完全权限（读取，写入）..
2.是你从快捷方式启动应用程序...确保shorcut属性是正确的....应该显示网络路径。
3.启动MS自己访问/然后尝试从文件中选择应用程序列表......会发生什么？
1. Verify that user that is accessing shared directory has full permissions (read, write) on that directory..
2. Are you booting the applicaton from a shortcut...make sure shorcut properties are correct....should show network path.
3. Boot MS Access up by itself/then try selecting the application from the file list...what happens?
这篇关于网络数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
