Post reply

How to Access the database off the network

  • December 30, 2003 at 1:38 pm

    #64900

    I have Access database linked with sqlserver. Rightnow users have to input login info in order to login into the database. Some of field technican want to take this Access database into field in order to look the information. What to do in order to access the database without prompting login info.

    Thanks in advance

  • December 30, 2003 at 2:08 pm

    #488273

    I am not sure you want that, but if All you do is query linked tables then:

    1.Delete the existing links

    2.Goto File --> Get ExternalData -->LinkTables

    3. Select ODBC DataSources on The Files Of Types option and Point it to your DSN

    4. Select the Tables / Views AND CHECK THE SAVE PASSWORD check box

    5.Go to town


    * Noel

  • December 30, 2003 at 2:36 pm

    #488284

    Hi Noeld!

    I want technician to access the database when there are in network. I want to see database locally without sqlserver prompting.

  • December 30, 2003 at 2:41 pm

    #488286

    Do you use NT authentication in your DSN setting? If not, try that.

  • December 30, 2003 at 3:03 pm

    #488290

    Hi Allen,

    I'm using sqlserver authenciation. I want to know how to access the database when technicians are in the field and login locally without conncecting to network or domain.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply