jaYPee wrote:
i have split my database and created a code that will look up for the
location of the mdb back end everytime the front end link has change.
i'm wondering if there is a way to just create and INI file to store
the location of database backend. 'cause it's very time consuming
sometimes when u change the front end (i.e. the query, forms, reports,
etc) from other computer and when u update the mdb files from other
machine it will look up again the location of database file.
thanks in advance
Simple, relink the frontend on one machine, then copy it to the other
machines. The link will not need updating on the other machines if you
use the same network share.
I've done something very "tricky" but messy... (had to solve having the
workgroup security file with the backend on a network share which may be
different at different client sites).
Using InstallShieldExpress
- during installation nstallShield prompts for the "data location"
- take this folder value and build it into the shortcuts InstallShield
will create for me
- In this shortcut I...
1) use the folder as value for the /cmd argument so it is passed to my
program.
2) use the folder as part of the path to my workgroup file
- when front-end opens it first checks this /cmd argument and attempts
to find and link to the database there and links automatically
Only problem I have is the shortcut can get too long if your path to
your back-end is really long.
Has anyone else come up with a solution to automate as much as possible
the use of Workgroup security and re-linking to a backend data file?
--
regards,
Bradley