开发者

Microsoft Access - Using the In Clause in a Query over a Network

So right now, we have a setup where ui.mdb and database.mdb are two separate access files. I am querying the databas开发者_StackOverflowe using the IN clause (ie "SELECT * FROM USERS IN 'DB\example_db.mdb'") and it works great on my local machine. The problem is that people are accessing the file over a public share in the network (ie "\computername\example_ui.mdb"). Once people try to use that query with the IN clause, they get the error:

c:\users\username\documents\db\example_db.mdb is not a valid path. Make sure the path name is spelled correctly and that you are connected to the server on which the file resides.

I did some research and I found this http://support.microsoft.com/kb/167452, but frankly, I don't really understand it. Does anyone have any familiarity with solving this issue?


You should use a full path, not a partial one. If you are 100% sure that everybody in the company has the same mappings, you can use comething like IN "X:\myFOlder\myFile.mdb".
This is using a mapping.
If mapping is not reliable, you can state a full absolute address using UNC (Universal Naming Convention): IN '\\MyServer\myShare\myFolder\myFile.mdb'

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜