I have an Access Database (*.mdb) running within another program. It includes and auto update feature, that constantly reads a *.dta file and updates the database accordingly.

However, it works for different periods of time, then I get a type mismatch 155 error. The only way I can fix it is to discard the current database and start a fresh one.

The *.dta file gets changed to either *.dt$ or *.dt~ and it's becoming very annoying.

It shouldn't be related to regional settings as everything is set to English (UK)

Please can someone shed light on my problem. Thank you very much.

Ian Young
Great Lakes Fine Chemicals