I was able to reproduce the problem using a trivial set of commands to the standard sqlite command tool:
On the Mac: gorp:~/2010 yeartech/yearbook tools/resource davedyer$ /applications/utilities/sqlite3-shell actiontool2.sqlite SQLite version 3.6.10 with the Encryption Extension sqlite> attach database 'indexer.sqlite' as indexer; sqlite> begin transaction; On the PC: M:\2010 yeartech\yearbook tools\resource>sqlite3 actiontool2.sqlite sqlite> attach database 'indexer.sqlite' as indexer; sqlite> begin transaction; sqlite> delete from indexer.preference_table; sqlite> insert into indexer.preference_table select * from preference_table; sqlite> commit; On the Mac: sqlite> delete from indexer.preferences_table; SQL error: no such table: indexer.preferences_table sqlite> delete from indexer.preference_table; sqlite> insert into indexer.preference_table select * from preference_table; SQL error: database disk image is malformed sqlite> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users