General Maintenance: How can I remove the Default Location in User Maintenance

From AutoCount Resource Center
Revision as of 04:30, 29 July 2022 by LaySwan (talk | contribs) (Created page with "'''Question:''' Previously there was Default Location assigned in user maintenance, but now unable to remove it or clear it. Is there any way to clear it? '''Version:''' 1.8 / 1.9 / 2.0 550px <u><b>Answer :</b></u> Yes, defined the User Login ID to clear the default location, do backup for this account book, and login AutoCount Management studio, go to <span style='color:red'>Tools > SQL Query</span>. [[File:Remove default loc2.png]...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Question: Previously there was Default Location assigned in user maintenance, but now unable to remove it or clear it. Is there any way to clear it?

Version: 1.8 / 1.9 / 2.0


Answer :

Yes, defined the User Login ID to clear the default location, do backup for this account book, and login AutoCount Management studio, go to Tools > SQL Query.


Click on Yes.


Key in the below SQL query and click on Execute

UPDATE Users SET Location = NULL WHERE UserID = 'ADMIN'


For Version 2.0, beside use sql query to remove the default location, user may update to version 2.0.29.202 or above, in these versions, user able to highlight on the Location and using keyboard Backspace or Delete button to clear it.


By: Cit Ta 220621, Lay Swan 220722, P220725


Go to menu

AutoCount Accounting 2.0 & 2.1


AutoCount Accounting 1.8 / 1.9
AutoCount Payroll
AutoCount POS


AutoCount On The Go
AutoCount Accounting Plug-In Documentations