PLease Help Me Please

[mothi]

Hi I have a secured database , i will be deploying the database to 14 users in Flash drives. So i will be having a shortcut in the flash drive and i will hide the main database in the flash drive.

IN the short cut target path , the access executable path could be different in user computers. So i do not want to keep changing the path of that. I just need some code which would recognize in what drive the access executable is stored and it will pick that path and connect it to shortcut on the flash drive. PLease Help me Regarding that.

They have to run the database off the stick they cannot copy the shortcut on their desktop. So please help me . I need help.

 

[Access_guy49]

You need code to look up the install path of Access in the registry.
This article gives examples on how to create, write, and read from keys.
http://support.microsoft.com/kb/145679

You will want to read out of this key for office 2000 (no spaces in the key, seems to display on my screen with spaces....hmm)
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\9.0\Access\InstallRoot\Path
Or use 11.0 instead of 9.0 for 2003.

 

[gemma-the-husky]

i doubt very much if the performance will be acceptable or reliable running off a data pen. I would not do this.