encrypting Linked tables

  • Thread starter Thread starter Ricky
  • Start date Start date
R

Ricky

I use Access 2000 and link to SQL tables using ODBC.
Is is possible to use Access 's encryption to encrypt the linked data ?
 
If you mean: "Can I use the encryption option of Microsoft Access to encrypt
the data stored within an SQL Server database",

the answer is: no.

Access encryption is actually performed by the underlying default database
management product, microsoft Jet. It is only applicable to Jet databases.
There is no way for Jet to encrypt or decrypt data stored in other database
products like SQL Server, afaik.

HTH,
TC
 
Thanks TC
I thought that would be too easy.
I'm using MySQL and the encryption function has not been
added.
 
Back
Top