Transmitting/Receiving Data via MS Access/ADO

Can someone give me a brief primer on data encrytion/security when
transmitting data between SQL Server and an MS Access database via ADO. Is
the data that is sent via ADO encrypted? f not, is their a way to do that?

My problem is that I need to send and receive confidential student ID
numbers in a manner that the number cannot be read in transit, nor can
someone query that information from the SQL database without proper
permissions. I just have not paid that much attention to encrytion/security
until now... what can I say.

David
.

Relevant Pages

  • Re: Connection between MDB and SQL Server
    ... According to your code,table2 is on Access database but I ... don't need to specify that it is Access table. ... How can ADO judge this is not a SQL table but Access ... >> data from Access into the table on SQL Server. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Simple Database
    ... I think ADO is the way to go then, with an Access database. ... > and MSDE is as much of a memory hog as a full SQL Server ...
    (alt.comp.lang.borland-delphi)
  • Big problem with duplicate field names when converting Access prog to work with SQL Server
    ... I am converting a large application that uses an Access database via ADO to ... With Access if there are duplicate field names they are ... I have just discovered to my horror that SQL Server will not qualify the ...
    (borland.public.delphi.database.ado)
  • Re: How to Mimic Access Externally Linked Tables using ADO?
    ... > using SQL Server for efficiency reasons. ... > connection up programmatically using ADO or ADOX or some SQL Server API? ... >> newsgroup, but if you have a good reason to send me e-mail, you'll find ... ADO does not have a query engine. ...
    (microsoft.public.data.ado)
  • Re: How to access the SQL server express from mfc application?
    ... There are different ways to do this via MFC. ... You could certainly try ADO, ... the entire contents of the database to a SQL Server Standard Server. ...
    (microsoft.public.vc.mfc)
Quantcast