offline sync problem

Yesterday I had a customer's 8 register system lose internet connectivity, so all the registers went off-line. They are using RMS 1.2 SR3 on a SBS Professional 2003 Server with XP SP2 registers. When internet connectivity was restored today, all but one of the registers sync'd. On the register that did not, the last transaction in the batch was at about 7:40pm yesterday. No transactions were recorded after that time. I manually took the register off-line today and could not find any batch or blind-closed batch with any transactions after 7:40pm.

I also checked, via MS Access and ODBC connection, the TRANSACTION table and no transactions recorded, either normally or off-line tagged.

Next I tried to connect via ODBC to the local register database, but it looks like there are no transactions there. (If I had the right database?)

How do you ODBC connect via MS Access to the local registers off-line database? What should I see in the TRANSACTION table there either before or after an off-line sync?

Thanks for your help.

--Rich

First thing I would check is to make sure the transactions did not actualy get uploaded to the main DB.

I would not know what you named your DBs but all transactions on a register either talk to the main DB or the offline DB.

The basic databases you will find on a clean install are: master model msdb Northwind pubs tempdb

Anything other then that would be one that you put on the system.

As for what information you should find, for an offline DB you should find transactions on the offline DB. Typicly you should only find the ones that that register did while on offline mode. If the transactions table is empty then they either did not get recorded (odd) or they did in fact get uploaded to the DB.

In the main DB check the register numbers, date and time on the transactions to located all the ones for the down time and see if it has any of the transactions from that register druing that time.

Good luck, Dak

"Rich" wrote: