Jump to content
Sign in to follow this  
radek225

Automatic logon to server via Ms Access 2010

Recommended Posts

radek225
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?

 

Share this post


Link to post
Share on other sites
orbs

do you mean that the form application should connect to the server before processing the linked database?

Share this post


Link to post
Share on other sites
radek225

But I have tables in another folder. So I need the script which try to login to a different folder

Share this post


Link to post
Share on other sites
orbs

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.

Share this post


Link to post
Share on other sites
radek225

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

Share this post


Link to post
Share on other sites
orbs

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?

Share this post


Link to post
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
Sign in to follow this  

×