Re: ODBC

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

First of all, you NEVER want to use the sa login, especially from
Access, which caches login information in clear text. You are creating
a giant security hole, not just for SQL Server, but for the machine it
is installed on or any that can connect to it on your network. If you
are trying to link tables, the best solution is to write DAO code
manipulating the TableDef objects. You can pass a connection string in
your code. If you're trying to do something else, please post the code
you are using or provide more details.

--Mart

On Tue, 20 Sep 2005 09:47:02 -0700, "Stuart Robins" <Stuart
Robins@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>I am running Access 2002 on W98 Second Edition.
>
>I am trying to connect to a SQL Server. The ODBC is set correctly and tests
>ok in control panel.
>
>When I connect to the database it puts the Network Login ID in the Login box
>instead of sa which is set in Control Panel.
>
>Can anyone help please?
.

Relevant Pages

  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)
  • Re: cannot acees two databases as owner
    ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
    (microsoft.public.sqlserver.setup)
  • Re: Database security design with ASP.net and form-based authentication
    ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: Credentials not being passed with remote access
    ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
    (microsoft.public.sqlserver.security)
  • Re: No db access after publishing web site
    ... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
    (microsoft.public.dotnet.framework.aspnet)