Access, MS Office, Programming

Using a Batch File to Start an Access Application Hosted on a Local Area Network

Microsoft Access
Microsoft Access

If you are creating MS Access applications, then you will probably want to set up custom workgroups and give your users the ability to log into your application as a workgroup user that has various levels of access. You will also want to host the Access application centrally on your LAN to avoid problems with multiple instances of the database existing.

The easiest way set up your application is by creating a custom .MDW (workgroup security) file and hosting this together with your main .MDB database file on your local area network for your users to access. Then in order for your users to be able to launch the application and log in from their desktop machines, you can create a simple batch file for them to click on.

For example, if you had your Access files on a network path such as:

\\MyNetwork\AccessApps\

Let’s assume your users are running MS Access 2002 on a Windows XP machine. This means that on their local machines, the default path to the MS Access executable would be:

C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE

This path above will of course vary based on the version of MS Access and the version of Windows that your users are running.

Continue reading “Using a Batch File to Start an Access Application Hosted on a Local Area Network”