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.
Hans,
You 'should' still be able to use the UDF to encrypt/decrypt the data. You
may need to create views that allow the decryption -but if the security
isn't done correctly, then any protection provided by encrypting the data
could be lost.
Please post the entire SELECT query, table definitions (DDL), and some
sample data.
See: http://www.aspfaq.com/5006
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Hans Munkwitz" <msnews.microsoft.com> wrote in message
news:u8ytHKWGHHA.2456@.TK2MSFTNGP06.phx.gbl...
>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.
>