LAN connection problem on distributed application

[funderburgh]

In the private school where I toil, I have developed an Access application which is widely distributed as an executable. A student recently "discovered" a security hole in our LAN that allowed students to access the shared folder containing the Access database used by the distributed application. I quickly made the folder password protected (windows vista/XP). On a remote work station I can now connect to the shared folder using the password, and open and update files (files that live there in addition to the Access database). However when I try to run the application on the same workstation, it acts as though it cannot open the database. Any help is welcome. Thanks

 

[Guus2005]

You can put a password on the access backend and remove the password on the folder.
Make sure that the backend is the only file in the folder.

You could migrate the backend form Access to SQL Server (Express) thus raising the bar.

HTH