Client / server data retrieval

I have a Client/Server application where the Client is MS-ACCESS 2000 and
the Server is SQL SERVER 2000. The two entities reside on separate
platforms(Machines). The server contains tables in which some
columns(fields) are encrypted and must therefore be decrypted to view them.
This works great when using UDF procedures to do the encrypting/decrypting.

My question is: How can I access the data either encrypted or decrypted from
the MS-ACCESS client using SQL via an ODBC connection. The normal data
transfer between the Client/Server is achieved using a Linked Database. The
normal SQL's utilizing the UDF's on SQL server do not seem to be accessible
using the normal MS-ACCESS Sql's.

Thanks in advance for any helpful suggestions....



--
Hans Munkwitz
Pace Data Systems, Inc.


.

Relevant Pages

  • Re: THREE EXCELLENT QA ANALYSTS AVAILABLE
    ... client/server applications on UNIX, WindowsNT/2000/2003 and Windows XP ... QuickTest Professional, Rational Products like Rational/SQA Robot, ... Sybase, Oracle 7/8i, DB2, MS Access, SQL Server 6.5/7.0 ... unit testing in different stages of Software Development Life Cycle ...
    (comp.databases.informix)
  • Re: Access to Visual Basic Conversion???
    ... Moving to sql server will not fix most performance problems. ... sql server is slower then ms-access on the same ... The only way you get better performance is to have good designs. ... for ms-access is the SAME as VB6 anyway. ...
    (microsoft.public.access.formscoding)
  • Re: THREE EXCELLENT QA ANALYSTS AVAILABLE
    ... client/server applications on UNIX, WindowsNT/2000/2003 and Windows XP ... QuickTest Professional, Rational Products like Rational/SQA Robot, ... Sybase, Oracle 7/8i, DB2, MS Access, SQL Server 6.5/7.0 ... unit testing in different stages of Software Development Life Cycle ...
    (comp.databases.informix)
  • Re: Multi user VB6 Access Backend Database
    ... I have a good number of clients using access applications of mine. ... As a note, the development language in ms-access is the same as VB, ... I can think of for that client. ... I mean, really, why run sql server with 5 or 10 users, and 50 ...
    (microsoft.public.vb.database)
  • Re: A little help with access forms.
    ... that field needs to be exposed to ms-access front end. ... sql server here..but just a JET file share). ... >> any query that tries to join multiple tables..that should be placed on ... my point was don't use queries built on the ms-access side if they join ...
    (microsoft.public.access.conversion)