Jump to content

Automatic logon to server via Ms Access 2010


Recommended Posts

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

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

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

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

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

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...