MS Access linked tables SQL Server

From: John (IDontLikeSpam_at_Nowhere.com)
Date: 09/21/05 

Date: Tue, 20 Sep 2005 15:00:28 -0700

Hello,

We have a bunch of client machines that use MS Access (pretty sure all of
them are XP) that has linked tables to our SQL Server 2000 database which is
on it's own domain and server. I was wondering if the data that is
traveling between each client that connects to our SQL Server (linked tables
from MS Access using the ODBC dsn in the control panel) is encrypted and/or
secure? I think I read somewhere on the internet that MDAC 2.6 or higher
the encryption is used by default? Just hoping someone could confirm to me
that this is true. Thanks in advance.

John

Relevant Pages

  • dts on machine without SQL Server
    ... I have an excel workbook that uses DTS via VBA Script and Referencing. ... The code does not work on other client machines who don't have sql server. ... No networking, all local files, all local access dbs ...
    (microsoft.public.sqlserver.dts)
  • Re: Recordsource only available to Administrator on clients
    ... far seems to suggest a permissions problem related to windows ... authentication (rather than to sql server or access itself), ... if users on client machines must be granted administrator ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Performance Hits - Second Post
    ... Make sure you have SP3a applied to the client machines. ... Microsoft Sql Server Storage Engine, ... > Andrew J. Kelly SQL MVP ... >> experienced this slow performance after the upgrade? ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server and client MDAC versions
    ... Another point to is that if is beneficial to have the client machines at ... the same or higher version of MDAC than the SQL Server installation ...
    (microsoft.public.sqlserver.clients)
  • Re: SQL or Access DB
    ... As far as encryption goes though... ... with Sql Server you can use SQL DMO and encrypt your stored procedures ... installation - Security was absolutely critical and in most instances, ... > then we create a nice gui around this database and sell it to automotive ...
    (microsoft.public.dotnet.languages.vb)