Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    New Jersey
    Posts
    103
    Thanks
    6
    Thanked 0 Times in 0 Posts

    ODBC Connection (Access 2000)

    I created a Database on the Departmental Shared Drive. The idea is to create reports which everyone in the department can run on their own. The problem I am having is that I can run the reports but everyone else can not. They have ODBC connection to the primary database so why isn't it prompting them for their username and password? All tables are linked to the primary database.

    Help!! <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: ODBC Connection (Access 2000)

    What are you using for a backend database, and are you using Access security? If the connection is to an Access back end and you used Access security, then your back end database want' properly secured and you didn't distribute the MDW file for the use of the other workstations.
    Charlotte

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: ODBC Connection (Access 2000)

    I presume you are getting an error message of some sort - what does the error message say?
    Wendell

  4. #4
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    New Jersey
    Posts
    103
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Re: ODBC Connection (Access 2000)

    I am using the primary database security. I am only using Access to link the tables and run reports. Everyone has access to the primary database using the ODBC connection so I am not sure why it isn't working. They get a "ODBC - connection failed to Ivantage" iVantage is the primary database. The strange thing is they can link new tables to the Access database and run reports off of it but then I can't open theirs either.

    Please help [img]/forums/images/smilies/sad.gif[/img]

  5. #5
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: ODBC Connection (Access 2000)

    What is your primary database - SQL Server, Oracle, DB2 or what? The ODBC connection failed message indicates that there is a problem with the connection that you created when some one else tries to use it. More than likely it has to do with the userid or password that is required to connect to the primary database, but the methods and the connection string varies depending on what the back-end primary database is.
    Wendell

Posting Permissions

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