I have a file dsn that I use to link SQL tables to access, the problem is that I Saved it on say L:\Data which is how it looks on my computer but others have different paths on their computers. I know the UNC path, but when I use this to create a file dsn it says fiel error #566. Is there a way to Link tables and pass through queries without having the path problem?
Any help is appreciated.
Any help is appreciated.