radek225 Posted October 3, 2013 Share Posted October 3, 2013 Hi! I have some aplication in Ms Access. All I want to do is, when I open file, should start some script, which trying logon to Serverfolder using user:admin password:admin If everything was made correctly then Msgbox "ok" I can't do this using vba in Ms Access, Is there anyone here who can help me? Link to comment Share on other sites More sharing options...
orbs Posted October 3, 2013 Share Posted October 3, 2013 do you mean that the form application should connect to the server before processing the linked database? Signature - my forum contributions: Spoiler UDF: LFN - support for long file names (over 260 characters) InputImpose - impose valid characters in an input control TimeConvert - convert UTC to/from local time and/or reformat the string representation AMF - accept multiple files from Windows Explorer context menu DateDuration - literal description of the difference between given dates Apps: Touch - set the "modified" timestamp of a file to current time Show For Files - tray menu to show/hide files extensions, hidden & system files, and selection checkboxes SPDiff - Single-Pane Text Diff Link to comment Share on other sites More sharing options...
radek225 Posted October 3, 2013 Author Share Posted October 3, 2013 Yes Link to comment Share on other sites More sharing options...
orbs Posted October 3, 2013 Share Posted October 3, 2013 try this: http://www.access-programmers.co.uk/forums/showthread.php?t=180602 quote: The simplest solution would be to link the tables again, this time checking the box that says "Save password" or something to that effect. Signature - my forum contributions: Spoiler UDF: LFN - support for long file names (over 260 characters) InputImpose - impose valid characters in an input control TimeConvert - convert UTC to/from local time and/or reformat the string representation AMF - accept multiple files from Windows Explorer context menu DateDuration - literal description of the difference between given dates Apps: Touch - set the "modified" timestamp of a file to current time Show For Files - tray menu to show/hide files extensions, hidden & system files, and selection checkboxes SPDiff - Single-Pane Text Diff Link to comment Share on other sites More sharing options...
radek225 Posted October 3, 2013 Author Share Posted October 3, 2013 But I have tables in another folder. So I need the script which try to login to a different folder Link to comment Share on other sites More sharing options...
orbs Posted October 3, 2013 Share Posted October 3, 2013 if your scenario is: form application is on local pc tables database is on server user does not have access to server then your solution is: RunAs the form application with /netonly (you can do this with AutoIt, or with basic means like batch file, or dedicated utility for better security) if this is not your scenario then please describe it more clearly. Signature - my forum contributions: Spoiler UDF: LFN - support for long file names (over 260 characters) InputImpose - impose valid characters in an input control TimeConvert - convert UTC to/from local time and/or reformat the string representation AMF - accept multiple files from Windows Explorer context menu DateDuration - literal description of the difference between given dates Apps: Touch - set the "modified" timestamp of a file to current time Show For Files - tray menu to show/hide files extensions, hidden & system files, and selection checkboxes SPDiff - Single-Pane Text Diff Link to comment Share on other sites More sharing options...
radek225 Posted October 3, 2013 Author Share Posted October 3, 2013 form application is on local pc tables database is Serverbase but application sometimes creates folders and folder path is: Serverfolder The problem is login to Serverfolder script can working without ms access. E.G While the Windows 7 is opening, the script could login to Serverfolder then I don't need login via ms access Link to comment Share on other sites More sharing options...
orbs Posted October 3, 2013 Share Posted October 3, 2013 if you want to make a script to login to serverfolder at startup, then obviously you are not concerned with security, so, if user has access to serverbase, then why not give access to serverfolder too? Signature - my forum contributions: Spoiler UDF: LFN - support for long file names (over 260 characters) InputImpose - impose valid characters in an input control TimeConvert - convert UTC to/from local time and/or reformat the string representation AMF - accept multiple files from Windows Explorer context menu DateDuration - literal description of the difference between given dates Apps: Touch - set the "modified" timestamp of a file to current time Show For Files - tray menu to show/hide files extensions, hidden & system files, and selection checkboxes SPDiff - Single-Pane Text Diff Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now