Access DB connectivity between users and administrator

%3CLINGO-SUB%20id%3D%22lingo-sub-1929279%22%20slang%3D%22en-US%22%3EAccess%20DB%20connectivity%20between%20users%20and%20administrator%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1929279%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20the%20Access%20DB%20that%20sits%20on%20a%20user's%20machine%20connected%20to%20the%20Administrator's%20copy%20of%20the%20Access%20DB%3F%26nbsp%3B%20If%20so%2C%20is%20it%20possible%20for%20the%20Administrator%20to%20use%20an%20SQL%20query%20that%20will%20collect%20data%20from%20every%20user's%20Access%20DB%20and%20put%20this%20data%20into%20the%20Administrator's%20Access%20DB%20copy%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20help%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJon71%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1929279%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Is the Access DB that sits on a user's machine connected to the Administrator's copy of the Access DB?  If so, is it possible for the Administrator to use an SQL query that will collect data from every user's Access DB and put this data into the Administrator's Access DB copy?

 

Thanks for the help,

 

Jon71

0 Replies