ODBC Driver for SQLServer Compact Edition (Everywhere)

[Guest]

In Access, I'm simply trying to link to a SQLServer CE database using an ODBC
driver, as you can do with other SQLServer servers. I'm not interested in
syncronizing to a mobile device.

I was hoping to use SQLServer CE as a substitute for the normal Access Jet
engine, to take advantage of encryption and security that Access does not
provide (or does poorly). I want to deploy a single-user Access application
with an easily deployable secure database. I'm distributing an app now with
just Access, but I've never been happy with the security. I'd like to make
the data tables inaccessible except through my compiled application.

I do have SQL Server 2005 Everywhere installed, (SQL Server 2005 Compact
Edition), and I've created a database from VS 2005 (after installing VS 2005
SP1 Beta) and so far have not been able to connect to that database from
Access. There is a .dll distributed with Everywhere: sqlceoledb30.dll that
has a description "OLEDB Provider" that I am hoping will work, but it is not
installed as an ODBC driver.

It seems impossible that I'm the first to attempt this. Any help will be
appreciated.

Office 2003 SP2, Win XP SP2, VS 2005 SP1 Beta
Thanks

 

[aaron.kempf]

use Accesss Data Projects then it's a much much much better solution

-Aaron