I'm using a computer that has an encryption program installed called "PGP Desktop". This app encrypts individual files in a folder so that you can only open them if you are running PGP Desktop and provide the unlock key.
I need to import data into SQL Server from the access database which is PGP Desktop encrypted. There is no password on the access database and I have PGP Desktop running in the background yet the SQL Server import wizard can't read the access database file. It appears to the import wizard to be scrambled and not a valid access file. I can certainly open the file using Access because Access somehow knows to use PGP Desktop.
How do tell the SQL Import wizard to open this file through PGP Desktop? My work around at the moment is to take all of the access database files out of a PGP Desktop folder which is not really ideal.
Cheers!