mainly making RMS HQ environment users aware of a bug that I found recently. I'm going to copy and paste my post that I sent to microsoft. The easy temporary fix is to change the cashier's password to not include the apostrophe. then try the 401 worksheet again. Good Luck.
If a cashier creates their password to include an apostrophe in their password, it will cause problems when the HQclient updates worksheet 401 to the HQ Server.
example: cashier sets their password = April'09 HQclient will update HQserver with statement similar to... UPDATE [Cashier] SET Password = 'April'09'
that statement will cause an error similar to... Incorrect syntax near 09 worksheet did not complete due to errors.
resolution would be to correct the way HQclient handles apostrophies in the password. Or do not allow cashiers to use apostrophes in their passwords.
Regards, Andy Miller RVP Business Systems - Boise, Idaho