Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2015
    Posts
    2

    Question Login Sql server linked tables automatic on event load of my login form

    Hello everyone... I'm a spanish speaker and my english is not very good, sorry... I have a question for you, I have a ms access aplication in Front End and linked tables to sql server 2008 r2 in back end.. everytime I open my aplication the linked tables ask to me for the user and password of the sql server user of the odbc conection. I want to conect to my sql database without login everytime the user open the aplication, I know that can be possible if I start session from vba code, but I'm not very good in vba code and I cant do the conection in this way, can you help me?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    You need to connect the tables again WITH SAVE PASSWORD on.
    this way it stays connected and won't ask.

  3. #3
    Join Date
    Apr 2015
    Posts
    2
    Dawm... it was too easy... thanks !! ..... works perfectly... but, I'm really wanting to do that from vba code 'cause if I do saving the password, anybody who open de desing mode of my application can easily stole information from de database... do you know the way to do that?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 0
    Last Post: 03-09-2015, 06:16 PM
  2. Access 2010 login to connect to linked tables
    By Back2Access in forum Security
    Replies: 3
    Last Post: 02-13-2015, 10:45 AM
  3. ODBC Automatic login
    By Metrazal in forum Macros
    Replies: 3
    Last Post: 10-09-2014, 03:08 PM
  4. Login form with nt login
    By hitesh_asrani_j in forum Forms
    Replies: 6
    Last Post: 09-22-2011, 11:43 AM
  5. Linked tables SQL Server login popup
    By geremore in forum Programming
    Replies: 3
    Last Post: 08-16-2011, 12:47 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums