I use Data Exchange for MS Access to convert a table in Access to a HanDBase file, but no matter where I save the pdb file, it makes a copy in "My Documents" when I use HanDBase Desktop to transfer the file to the iPhone. Now I have two files of the same name in different folders. I realize that the default location for these files is My Documents, but it would be nice to be able to change that location - ideally, I'd like to have it synch to a network folder where files are backed up regularly.
I'm also having trouble synching to Access. I place the converted file in my "Sync" folder and use Sync Exchange to connect back to the Access table and get sync errors (Index or primary key cannot contain a Null value). When I remove the primary key, I get duplicates (merging, not synching?), and the synch is to the file in "My Documents", not the one in my Sync folder that I set in the Sync Exchange settings. Also, contrary to the documentation, whenever a file in the Sync folder is modified, HanDBase Desktop asks me to install the file on next sync - I thought files in this folder automatically update without re-installing. What am I doing wrong?
I'm using the latest iPhone App and HanDBase Desktop version 4.1.5 (with HanDBase Professional for iPhone Add-on 4.1 Build R1) and documentation from 2007 - have either of these been updated?
p.s. Actually, the only reason I'm synching to Access is to generate simple reports. Here's hoping that HanDBase Desktop will get more robust report writing capabilities!