

InterviewSolution
Saved Bookmarks
1. |
Solve : Delete ldb in startup folder? |
Answer» <html><body><p>I have locked down workstation which multiple users use to access a MS Access database. The database automatically starts up when the machine is rebooted. I've done this by placing the databse in the startup folder. The problem is, when I reboot the PC (or if it ever crashes) the .ldb file is still in the startup folder. It then displays an error because it tries to run the .ldb file. Is there <a href="https://interviewquestions.tuteehub.com/tag/anyway-2436609" style="font-weight:bold;" target="_blank" title="Click to know more about ANYWAY">ANYWAY</a> of deleting this .ldb file before it runs?<br/><br/>I was thinking of possibly a batch file to run at startup to delete this .ldb file. Question is what should go in the batch file and how do I get the batch file to run before windows tries to open the .ldb file?What version of windows are you running? I know XP has a way to run a batch file on start up and on shut down. I am sure vista can do the same thing.<br/><br/>For XP you can setup a group policy. If your not in a domain than go to the machine and type gpedit.msc from a command prompt. Than open Windows settings and you will see where you can add the scripts.<br/><br/>Hi, It's XP, but I've just <a href="https://interviewquestions.tuteehub.com/tag/realised-2977718" style="font-weight:bold;" target="_blank" title="Click to know more about REALISED">REALISED</a> I can put the database in a different folder and put a shortcut to the database in the startup folder. However, I have another little problem:<br/><br/>The PC is part of a domain. When the PC boots up it runs a login script to map to the network drives. Sometimes this runs a bit slower than other times. Because the database has tables on the network, if the login script is running slow the database starts up and errors because it cannot find the backend tables.<br/>Is there any way in a batch file to write in a delay of say 30 seconds then open the database? In this case I can guarantee the login script will have run.In the group policy open admin templates and than system...scripts. Than enable "Run Logon Scripts Synchronously."<br/><br/>This forces the login script to <a href="https://interviewquestions.tuteehub.com/tag/finish-989314" style="font-weight:bold;" target="_blank" title="Click to know more about FINISH">FINISH</a> before the desktop is created.<br/><br/>Yes this seems to work. Thanks.<br/><br/>Unfortunately I've just spotted another problem.<br/>I've used a program someone suggested called KaneBT to hide the start button and taskbar. This does hide the taskbar and start button however if I double <a href="https://interviewquestions.tuteehub.com/tag/click-918865" style="font-weight:bold;" target="_blank" title="Click to know more about CLICK">CLICK</a> where the start button should be, I still see the options <a href="https://interviewquestions.tuteehub.com/tag/like-537196" style="font-weight:bold;" target="_blank" title="Click to know more about LIKE">LIKE</a> My Computer etc. I can't allow this to happen. I just want users to see a database front screen (similar to a kiosk user) and not be able to do anything else.<br/><br/>Any ideas?</p></body></html> | |