Re: Client / server data retrieval
- From: "Arnie Rowland" <arnie@xxxxxxxx>
- Date: Wed, 6 Dec 2006 11:23:03 -0800
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@xxxxxxxxxxxxxxxxxxxxxxx
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.
.
- References:
- Client / server data retrieval
- From: Hans Munkwitz
- Client / server data retrieval
- Prev by Date: Client / server data retrieval
- Next by Date: Re: Problems With Client Connections
- Previous by thread: Client / server data retrieval
- Index(es):
Relevant Pages
|
