Hey Guys,
I have this same issue. I am using Trimble Kenai tablets with windows 10 OS and ArcPad 10.2. I created projects in ArcMap 10.3 and used the ArcPad data manager to transfer the projects to my desktop for loading onto the tablets at a later date. On my desktop, the projects work fine, same ArcPad program as the tablets. When I loaded the projects onto the tablets, they worked fine the first time I opened them, then I started getting an error: "Microsoft SQL Server Compact Edition initialization error 80040154. ArcPad will operate with some functionality disabled." After that, I get the "Failed to load 1 layer(s) .apx" message and the editable layer that I need to work with will not load. I need some advice on how to fix this problem. I tried unchecking the "Check SQL engine on startup" box under ArcPad>Options>General tab, however that only made the 80040154 error message go away but did not let the .apx layer load. Advice/Help/Suggestions would be greatly appreciated.
Regards,
RoyVern
The initialization error that is described here is to do with the SQL Server CE installation. Be sure that you have version 3.1 installed. This is installed when you install ArcPad. Look in Add/Remove Programs to be sure what version you have. Consider whether there's a possibility that you may have upgraded the version of SQL Server CE on your machine for some other purpose (another app perhaps).