Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Find MSAccess.EXE \\Server\Path name ? 2

Status
Not open for further replies.

LittleSmudge

Programmer
Mar 18, 2002
2,848
GB
Is there any way of getting Access to admit the Server and Path name of the MSAccess.EXE that is currently running.



I have a text box control txtInfo on a form - so I need something like

txtInfo = ???????

G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.

Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need! :-D

 
Use the Syscmd function

SysCmd acSysCmdAccessDir

I hope this helps
 
Thanks John

SysCmd(acSysCmdAccessDir) worked great.

So:-
You have chosen to recognize JohnLowell for a helpful or
expert post! Thanks for letting JohnLowell know their post was helpful.









G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.

Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need! :-D

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top