|
Answer» 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 ANYWAY of deleting this .ldb file before it runs?
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.
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.
Hi, It's XP, but I've just REALISED 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:
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. 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."
This forces the login script to FINISH before the desktop is created.
Yes this seems to work. Thanks.
Unfortunately I've just spotted another problem. 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 CLICK where the start button should be, I still see the options LIKE 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.
Any ideas?
|