Hello all,
I wasn't sure what the correct forum would be for this question so here goes...
I have kind of a strange problem (well, to me anyway) and I am having trouble figuring it out. I have a Microsoft Access DB that I have created that I have split into a FE/BE. I found a utility on the web that I could use to automatically push a new copy of the front end to the user's machines so I don't have to manually go around to each desktop and recopy the FE everytime I make a change. What this utility does is check a version number that I create, if it doesn't match it gives a message to the user stating it is an old version and then it creates a batch file that deletes the old FE, copies the new FE and then attempts to re-open Access with the new FE.
Now, my problem is that I have user-level security enabled on the DB so that the users have to open the DB with the special shortcut that I create for them. This will prompt them for their user name and password. When the batch file is running, it is trying to re-open the DB through the Access application and is bypassing the security, which gives a permissions error when the DB re-opens. If I click OK, close Access and re-open then it works fine and I can see that the copy worked.
My question is this: can I change the batch file to open using the shortcut instead of the application shell? My batch file skills are not so good and so I don't even know if this is possible.
Thanks in advance for any help.