Access FE link to two SQL database using ODBC...

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Paul (paul_mak_at_hotmail.com)
Date: 06/11/04 

Date: Thu, 10 Jun 2004 22:52:56 -0700

I have an Access FE with tables link to two SQL BE using ODBC connection. I
configured the two ODBC as the system DSN to the client workstation. With
the way Access FE database design, all the tables for the forms link to one
SQL database. Both SQL databses are used for the reports. The problem is
when opening report, a pop up dialog box asking the ODBC connection, a check
box for the "trust connection" or user need to type in the user name and
password for the "other" SQL database. I told the user just to select the
"trust Connection" and it works. However I like to get rid of this annoying
dialog window? Thanks.

Relevant Pages

  • Re: AS400 to Access
    ... I have a vb program that opens an painfully slow ODBC connection to the 400 ... simply do an Insert for each record into our SQL server, ... > and internal employees I think some of the data will be able to be handled ... > adapter then update the Access OLEDB data adapter using the same dataset. ...
    (microsoft.public.dotnet.languages.vb)
  • RE: SQL server vulnerability through ODBC
    ... they could set up an ODBC connection to the SQL database and then went into ... SQL Server doesn't care what ODBC application the client uses, ...
    (microsoft.public.sqlserver.security)
  • Re: SQL server vulnerability through ODBC
    ... Look into Application Roles in SQL Server. ... You can grant the necessary select/insert/delete/update privileges to the ... from setting up an ODBC connection or some way in SQL administration to ...
    (microsoft.public.sqlserver.security)
  • Re: Use Group Policy to set ODBC
    ... Is there any way to automate the ODBC connection setup using group policy? ... Both solution can not provide SQL Authentication, ... Cahnge NameofServer + NameofDatabase ... PART "Driver:" EDITTEXT ...
    (microsoft.public.win2000.group_policy)
  • Re: Using Projects saved in an ODBC database
    ... This is the first I've heard of anyone saving to a VFP database. ... The documentation I have only mentions SQL Server and Oracle. ... > error when I try to Open from an VFP8 ODBC connection. ...
    (microsoft.public.project)