I have the database and server set up everything else is working and changes are happening on other computer but I can't assign shifts when connected in sql
@@omarba6972 you need to enter the correct password for the user sa that you use in SQL server. + Make sure the user sa has dbo rights on your SQL database.
Hello sir I'm sorry I don't have the database architecture but you can take a look at the database file . It's a MS Access file called att2000.mdb located in the software folder.
There is no direct method to create new file but you can follow these steps to have a new empty database file : 1- In the software go to Backup Database to save your current software data into a separate file (like attBackup.mdb) 2- Then go back to the software, go to Data menu and choose Initialize System. this will wipe all the data and give you an empty database * PS : there is another way to have a new att2000 file : you can install the software on another computer (but without entering any information in your software) and then go copy the file att2000.mdb from the program directory to your usb drive.
@@ZKTIMETUTOS Thank you so much for your reply. I will check about the steps. I am having some issues with "Download attendance logs" from the systems. When I click on that, it takes taking long time and freezing. Do you have any idea to fix this? Also, based on your reply, if I did "Initialize System", it will delete all my users? Should I have to do this => "go copy the file att2000.mdb from the program directory to your USB drive." from the device or from the system? If you could guide me to fix the "Download attendance logs" freezing issue, It would be greater :)
I have problème whene i insert a New département, i can't insert it Hi tell me cannot insert thé value nulle into Columna 'depid' please i need thé responce
@@ZKTIMETUTOS salut, merci pour votre question, j'ai résolu le prb d'insertion mais un autre prob dans la supp d'un département comme s'il ne trouve pas l'enregistrement pour la supprimé. Mais est ce qu'on peux partager la bdd Access seulement sans l'importe a SQL server? Merci
Oui vous pouvez partager la base Access sur le réseau si vous voulez mais seulement pour 2 à 3 postes maximum. Pour la configuration de timezone elle ne marche pas pour toutes les pointeuses ça dépend de son modèle.
ami amar pc tay windows deyar karony softower coly jai tai new softower instal kari but ager kicoi data pacci na aita ki vabe pabo vai plz bolban vaiya
Hello thank you for the video, it really helped out.
Excellent Sir. I salute you 🥰
I have the database and server set up everything else is working and changes are happening on other computer but I can't assign shifts when connected in sql
Do you have an error message about this problem? Please send any screenshot to my email : zktime.tutos@gmail.com
@@ZKTIMETUTOS I have the same issue. Can't present any error as there is no error message/screen. It simply does not assign shifts to employees.
Is there any way to auto transfer data from machine to database directly with every Employee chk in or out ?
right click the machine and click on Import from machine to software
May I request you to advise me about how can I link with level 1 user's pc with superuser's pc in LAN in this version of attendance system.
you are the best thank you so much
muy bueno, me funciono muchas gracias
De nada , me alegra mucho saberlo.
Great... thanks for support
You're welcome
excellent thank you very much
can you make video how i can access my biometric device using internet and download the data from another network
HI SIR CAN YOU HELP ME TO FIX THIS ERREOR : "Login Failed for user "sa" ?? (ZKTECKO Attendance Management System)
@@omarba6972 you need to enter the correct password for the user sa that you use in SQL server. + Make sure the user sa has dbo rights on your SQL database.
please i want to develop my own interfaces but i need database architecture to build based on it, please
Hello sir I'm sorry I don't have the database architecture but you can take a look at the database file . It's a MS Access file called att2000.mdb located in the software folder.
@ ❤️
Why does not find object give userinfo error?
hello wanna ask how to connect sql database not from local server ? can you teach me ? thank youu
Do you mean the software database is stored in another sql server ?
@@ZKTIMETUTOS no sir
but now i already done
thx for ur reply sir
Thank you so much
hi sir how to use ZKTime on anohter pc
I want to connect with mysql database not sql server could you please help me?
I'm still looking for this solution, I tried many times to connect with MySQL but nothing so far.
Sir, would you please guide us to connect ZKTeco machine database to Oracle database
which version of oracle are you using ?
10g database
Hello Brother,
Can you please tell me how to create a new att2000.mdb file?
There is no direct method to create new file but you can follow these steps to have a new empty database file :
1- In the software go to Backup Database to save your current software data into a separate file (like attBackup.mdb)
2- Then go back to the software, go to Data menu and choose Initialize System. this will wipe all the data and give you an empty database
* PS : there is another way to have a new att2000 file : you can install the software on another computer (but without entering any information in your software) and then go copy the file att2000.mdb from the program directory to your usb drive.
@@ZKTIMETUTOS Thank you so much for your reply. I will check about the steps. I am having some issues with "Download attendance logs" from the systems. When I click on that, it takes taking long time and freezing. Do you have any idea to fix this?
Also, based on your reply, if I did "Initialize System", it will delete all my users?
Should I have to do this => "go copy the file att2000.mdb from the program directory to your USB drive." from the device or from the system?
If you could guide me to fix the "Download attendance logs" freezing issue, It would be greater :)
Whats the server name in sql server. I can't find it. How to find it?
The SQL server name is the same name you see when you open SQL Management Studio before you log in.
I have problème whene i insert a New département, i can't insert it
Hi tell me cannot insert thé value nulle into Columna 'depid' please i need thé responce
Bonjour, je m'excuse pour ne pas avoir répondu plus tôt. Est-ce que vous avez toujours le même problème ?
@@ZKTIMETUTOS salut, merci pour votre question, j'ai résolu le prb d'insertion mais un autre prob dans la supp d'un département comme s'il ne trouve pas l'enregistrement pour la supprimé. Mais est ce qu'on peux partager la bdd Access seulement sans l'importe a SQL server? Merci
@@ZKTIMETUTOS j'ai une autre question, j'ai suivi les étapes pour faire une timezone mais ça n'a pas marché je ne sais p pourquoi ?merci
Oui vous pouvez partager la base Access sur le réseau si vous voulez mais seulement pour 2 à 3 postes maximum.
Pour la configuration de timezone elle ne marche pas pour toutes les pointeuses ça dépend de son modèle.
thanks a lot
ami amar pc tay windows deyar karony softower coly jai tai new softower instal kari but ager kicoi data pacci na aita ki vabe pabo vai plz bolban vaiya
Sir we didn't understand your language, please write it in English
شكرا جزيلا
vaiya ami amar ager dives teky poraton list gula ki vabe pabo plz bolben vaii
Sir we didn't understand your language, please write it in English
Hey men, why are you talking bangla ?? do you think they are benagali ?? 😂😂
where is the script file?
plz I need the software of ZKTime 5.0
www.mediafire.com/file/ioo4jgcp7ii3gj8/ZKTime5.0.rar/file
Nice video thanks 🙏
you r the best thank you so much