Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Lock out people from logging in when backup 1
- Thread starter Tianjin
- Start date
-
1
- #2
Since Accpac is an accounting system it is prudent (accountants love that word) to have all data files closed before a backup is run, regardless of the database used.
It is possible to backup open files using some backup software, but this can have undesireable results when you restore. What happens if someone posts a batch while the backup runs? Many tables are touched during a post and some files may be backed up before the post and others after the post, leaving you in an inconsistant state if you restore the data.
Data cannot be corrupted by a backup (provided the backup does not lock the data files), but your backup could be worthless if transactions where posted during the backup.
It is possible to backup open files using some backup software, but this can have undesireable results when you restore. What happens if someone posts a batch while the backup runs? Many tables are touched during a post and some files may be backed up before the post and others after the post, leaving you in an inconsistant state if you restore the data.
Data cannot be corrupted by a backup (provided the backup does not lock the data files), but your backup could be worthless if transactions where posted during the backup.
- Thread starter
- #3
There is no logout function.
In 5.3 you can restrict users login to specific days and times, say from 8:00 am to 5:00 pm. I am not sure what happens to any users still logged in at 5:00 pm, but I somehow doubt if they will be forcefully logged out.
In Accpac you can click on Help, Lanpak Users and get a list of active users, and then ask them to logout.
Backups are normally run late evening or early morning, so there should not be any active users. Any user still active in Accpac has simple forgotten to logout, and normally a warning letter will resolve that problem.
In 5.3 you can restrict users login to specific days and times, say from 8:00 am to 5:00 pm. I am not sure what happens to any users still logged in at 5:00 pm, but I somehow doubt if they will be forcefully logged out.
In Accpac you can click on Help, Lanpak Users and get a list of active users, and then ask them to logout.
Backups are normally run late evening or early morning, so there should not be any active users. Any user still active in Accpac has simple forgotten to logout, and normally a warning letter will resolve that problem.
- Thread starter
- #5
Hi ettienne,
Restricting users login to speific times definitely could sovle my backup issue. However, our accpac ver. is 5.1 or 5.2. in which the function you mentioned above was not included. So upgrade accpac to ver 5.3 may be the only choice. I will look through help file to see how to make this happen.
I do appreciate for all you helps
Tianjin
Restricting users login to speific times definitely could sovle my backup issue. However, our accpac ver. is 5.1 or 5.2. in which the function you mentioned above was not included. So upgrade accpac to ver 5.3 may be the only choice. I will look through help file to see how to make this happen.
I do appreciate for all you helps
Tianjin
- Status