| Arnie Rowland 2006-12-06, 7:14 pm |
| 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.
>
>
|