Users on point of sale

EZ one! Go to the RMS Administrator and log in to the database. type the following into the query window: SELECT * FROM Cashier and click on the green arrow. Voila!

Thanks for this script. Maybe in the future before publishing such scripts to all of public newsgroups - you could just email instead.

We run a secured system - with a protected Admin account for the purpose of containing centralized data. Granted you have to know the SQL pass to query in Admin (for now...) - but when if that is widely known, and/or end users can find the direction to change it here on public, it is all kind of pointless.

Your post should be pulled.

Point taken! I'll try to temper my enthusiasm in the future!

Jerry, I commend you for posting the script for all to use and learn from. That is what this forum is all about. Please do not limit your help to email only, only a few people would learn from it then. The majority of 'end users' here really appreciate the help. By the way, this is an 'end users' forum, so why not help everyone. If somebody doesn't want to help us end users, they should stick to the partners only newsgroup since none of us have access to it. I applaud your efforts in trying to help us. Craig

We have a new installation of a Point of Sale hardware/software bundle that's had all of the inventory & pads set up. The problem is that in the shuffle the manager username & password got misplaced. We're pretty sure that we know what the password is, but is there a way to get the names of all of the users created in the system? We can currently login only as one of the cashiers. If we can't get the username, is it possible to create a new database and clone the pads & inventory items from the old database? Thank you

I must agree with Craig one this one too. It is difficult to gett answers when you need them. Jeff, the update command would be: UPDATE Cashier SET (Password='yadayada') WHERE [ID]=IDNumber;

--or-- UPDATE Cashier SET (Password='yadayada') WHERE [Name]='yourname';