Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

« previous next »
Pages: [1]   Go Down

Author Topic: Delete ldb in startup folder  (Read 3838 times)

0 Members and 1 Guest are viewing this topic.

Recall

    Topic Starter


    Rookie

    Delete ldb in startup folder
    « on: July 17, 2008, 06:58:56 AM »
    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?
    Logged

    Spoiler



      Specialist

      Thanked: 50
    • Experience: Beginner
    • OS: Windows XP
    Re: Delete ldb in startup folder
    « Reply #1 on: July 17, 2008, 07:11:20 AM »
    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.

    Logged
    Whenever I watch TV and I see those poor starving kids all over the world, I can't help but cry. I mean I would love to be skinny like that, but not with all those flies and death and stuff." - Mariah Carey, Pop Singer

    Recall

      Topic Starter


      Rookie

      Re: Delete ldb in startup folder
      « Reply #2 on: July 17, 2008, 07:29:09 AM »
      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.
      Logged

      Spoiler



        Specialist

        Thanked: 50
      • Experience: Beginner
      • OS: Windows XP
      Re: Delete ldb in startup folder
      « Reply #3 on: July 17, 2008, 07:35:32 AM »
      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.

      Logged
      Whenever I watch TV and I see those poor starving kids all over the world, I can't help but cry. I mean I would love to be skinny like that, but not with all those flies and death and stuff." - Mariah Carey, Pop Singer

      Recall

        Topic Starter


        Rookie

        Re: Delete ldb in startup folder
        « Reply #4 on: July 17, 2008, 08:33:41 AM »
        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?
        Logged
        Pages: [1]   Go Up
        « previous next »