Networked Databases

%3CLINGO-SUB%20id%3D%22lingo-sub-1554964%22%20slang%3D%22en-US%22%3ENetworked%20Databases%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1554964%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20use%20a%20number%20of%20networked%20databases.%20Different%20analysis%20reports%20will%20look%20for%20data%20in%20these%20databases.%20The%20problem%20is%20that%20the%20path%20is%20through%20the%20machine's%20username%2C%20which%20of%20course%20changes%20on%20each%20computer.%20I%20would%20like%2C%20without%20going%20through%20VBA%2C%20to%20integrate%20into%20the%20access%20path%20visible%20in%20the%20cell's%20formula%2C%20a%20way%20to%20find%20automatically%20the%20user%20name%20so%20that%20it%20can%20go%20and%20retrieve%20the%20data%20in%20the%20right%20place.%20I%20would%20also%20like%20to%20avoid%20moving%20databases%20in%20a%20common%20folder%20and%20outside%20the%20user%20folder.%20(See%20attached%20file%2C%20For%20example%20in%20cell%20B3%2C%20i%20would%20like%20to%20automatically%20replace%20%22Vincent%22%20in%20the%20acces%20path)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%20for%20your%20answers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EVincent%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1554964%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello,

 

We use a number of networked databases. Different analysis reports will look for data in these databases. The problem is that the path is through the machine's username, which of course changes on each computer. I would like, without going through VBA, to integrate into the access path visible in the cell's formula, a way to find automatically the user name so that it can go and retrieve the data in the right place. I would also like to avoid moving databases in a common folder and outside the user folder. (See attached file, For example in cell B3, i would like to automatically replace "Vincent" in the acces path)

 

Thank you in advance for your answers.

 

Vincent

 

0 Replies