Can I use ADOCE to access tables created directly with the Windows CE database APIs?
Yes, sort of. ADO provides more functionality than the underlying Windows CE database functions. The only way it can do this is by storing extra information about each table. If you create a table using CeCreateDatabase (sic) then ADO will not be able to “see” that table. Alternatively, if you create a table using ADO’s “CREATE TABLE” syntax then both ADO and the CeOpenDatabase (etc) functions will be able to use the data. Note, though, that accessing a table using both ADO and the Ce database functions is “not supported”. However this is mostly because CeWriteRecordProps allows you to write different data types for a given field on different rows (it’s also because we’ve never tested this scenario). If your application behaves “normally” then in practice you probably won’t have any problems. Note that all CE database specific features are supported by ADO even though other MS database engines don’t have corresponding features (usually because they’re not necessary). E.g., you can spec
