found out that db collation and server collation differ giving trouble when importing csv at stocktake (collation error on join). so I changed collation to the default sql2k one Latin1 etc.. (so server and db match) (from sql_....) this works fine but when starting the POS it reports immediately 'row could not be found or could be altered", and the pos program exits straight away.
any clues how to solve?
Thanks Gosling