Bypass the SQL Server Login

Posted on 2006-05-05
Last Modified: 2008-03-04
I have built an Access front end using a SQL server database.  Is there a way to bypass the SQL Server login pop up when the user starts the application.  All of the users have the same login and there is no password to the database.
Question by:AaronGreene1906
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    Is this a Access Project (based on a SQL Server database) or a Access Database (with linked tables to the SQL Server database)?
    LVL 38

    Accepted Solution

    If it is linked tables then to the lower right of the of the box that you select is a check box for "save password" check that box even if there is no password required.
    LVL 38

    Expert Comment

    by:Jim P.
    Glad to be of assistance. May all your days get brighter and brighter.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now