Home Page link  

Error 206 The register is not in the database

 

Point-Of-Sale Software - - MS Point Of Sale software discussed here

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Error 206 The register is not in the database Rene 05-31-2007
Posted by Rene on May 31, 2007, 5:29 pm
Please log in for more thread options
I'm having this major problem I delete the register in the manager and now I
can't get logged. I've tried some proceedings I saw in this forum and doesn't
work( setting the registers # through the Administrator). Please can someone
help !!

Posted by convoluted on May 31, 2007, 6:53 pm
Please log in for more thread options
Hi Rene

You could run a SQL query to add your register back, but one of the things
I've learned about RMS in the few months I've been working with this software
is that sometimes there are multiple tables on the database that need to be
updated with your queries; my suggestion is to wait and see if more
experienced users can add to this disclaimer and suggest additional queries
to update other tables I may not be aware of.

In administrator, connect to your database then run
select * from register

if the results are blank then you indeed deleted your registers; if there
are results then view the number field to determine how to configure your
register setting in the register tab in administrator - configuration

if your register table is blank, use this to get back up running
BACKUP FIRST

insert into register
(description, number)
values ('new register', 1);

this will create register number one for you with a register name of "new
register", but will have no other register settings; go into store ops
manager - database - registers and manually assign your register settings in
terms of receipt printers, cash drawers, pole display, etc

hope this helps....and remember to backup daily and often....

"Rene" wrote:

> I'm having this major problem I delete the register in the manager and now I
> can't get logged. I've tried some proceedings I saw in this forum and doesn't
> work( setting the registers # through the Administrator). Please can someone
> help !!

Posted by Rene on May 31, 2007, 9:57 pm
Please log in for more thread options
Thank you very much, that solve my problem I was very worried. Extremely
useful information please take note.

Rene

"Rene" wrote:

> I'm having this major problem I delete the register in the manager and now I
> can't get logged. I've tried some proceedings I saw in this forum and doesn't
> work( setting the registers # through the Administrator). Please can someone
> help !!

Similar ThreadsPosted
ERROR 206 REGISTER NOT IN DATABASE November 19, 2007, 8:13 am
Not found Error 206: the register is not in the database December 24, 2005, 8:15 pm
Setting up second register, how to connect to database October 18, 2006, 2:31 pm
more than one register connected to the same store database January 4, 2009, 5:04 am
error on POS register February 13, 2007, 3:11 pm
Database offline error when database is local December 22, 2008, 1:42 pm
Error using the Export Database Wizard to export store database in March 8, 2008, 9:02 pm
Database error in POS 2.0 July 7, 2008, 4:04 pm
error on database login December 15, 2005, 7:35 pm
Database Backup Error February 25, 2007, 11:54 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap