Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Pensylvania - USA

    Question Unanswered: Access Front End - Auto Login?

    Here's a "new" problem. I have this database set up so that it has an access front-end and an SQL backend. When I open the database on a computer with the SQL Server client installed it runs fine. When I open the database (access front-end) on a computer without the SQL client installed it prompts me to enter some login information to connect to the server. Is there any way to modify this front-end/backend so that the login information is automatically entered and it does not prompt the user to enter it? Just to let you know to make the front-end I used the link tables wizard to link the tables to the SQL Server.
    "Me only have one ambition, y'know. I only have one thing I really like to see happen. I like to see mankind live together - black, white, Chinese, everyone - that's all."
    - Bob Marley

  2. #2
    Join Date
    Jul 2003
    I don't know if it works with SQL, but you can put /user and /password in the command line.

    Check Access help for it: optional command line or something like that...

    Hope this helps!
    ---Do not send e-mail---
    "New Big Bang Theory: God said unzip universe"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts