Database shortcut and Batch file

[mothi]

Hi I created the shortcut for the secured database and done with filling up the target fields with correct path leading to the database.

But as you know

The path has to be like this

C:\My Computer\Local Disk C\ Program Fiels\ MS OFfice\ Office 11\ MS Access .Exe wrkgrp........


THe Shortcut would be accessed by multiple users lets say 10 users So all the users have to have the same path . I mean they need to have MS Access executable in the C drive but not on another drive to work.

I would like the path of the file to be flexible , even if the users have Access Executable file in different drives It should still work. So I read about batch file concept. PLease walk me through this , i mean how to create a batch file.........PLeae Help me regarding that....... Pleae guys help me.....

 

[HiTechCoach]

Since you can not share a Access database by having multiple users iopeing teh same file, you must split your database.

Is your datasbase already split?

The back end and workgroup file (.MDW) will be in a network shared

The front end will be on each local PC with a shortcut the launches the local copy of the Front End using the .MDW from the network share..

You may also want to check out this:
FRONT-END AUTO-UPDATE ENABLING TOOL