encrypting Linked tables

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 ?
 
T

TC

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
 
R

Ricky

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't send emails on new PC 1
Cannot open file with password protect. 0
Encryption in Access 1
Access 2007 encryption 0
Encrypting privacy information in MS Access fields 1
Encrypt only Back-End in Split DB 5
Problem with Upload Center on Office 2010 when using encrypted area on disk 0
Access 2007 Command Line /compact encrypted .accdb 2

Top