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'
精彩评论