Run application from a Jump drive

[CD Tom]

I've had a request for a user wanting to know if my application can be installed on a jump drive do he can take the jump drive to different computers and run it. In my application I extract files out to the C: this wouldn't create a problem but not sure what other problems the jump drive might cause. How would I go about making sure that my application would be able to know the drive location of the jump drive seeing that it might be different on different computers. Has anybody out there tried this?
Thanks for any suggestions.

[DonRayner]

Hi Tom,

The following code would give you the drive name in a string format that you are running your application from. If the app is going to be run from an UNC path then you would have to add some more code to check for that as well.

left(currentproject.Path,3)

If your DB path was "C:\Projects\My Projects\xxx\DB 1.mdb", you would get a string of "C:\" returned. But if the path was "\\myserver\pro jects....." all you would get back is "\\m".

Welcome to Bytes.

[missinglinq]

I troll thru this forum and four other Access forums/newsgroups, an average of 8-10 times a day, and the week never goes by without my seeing one or two threads dealing with chronic corruption when trying to run a database using removable storage devices. I have never seen any response that comes even close to explaining the cause of the problem. The only thing that comes to mind is, perhaps, the way data is accessed thru these devices. Access databases tend to become corrupt when connectivity to the back end is interrupted.

If I were doing this, I'd copy the data to the PC being used, run the app, then copy the data back to the removable drive, leaving a copy on the PC. This will give you a fall back position should something go awry.

Linq ;0)>

[CD Tom]

I'm able to run the program on the jump drive but I think if what your saying about the currupt database I might let this user know that it's not advisable to do it this way and the if the database gets currupt I'm not responsible. The program has a way to backup the data and restore it on different machines and that's the way most users move from one machine to another. Thanks for the advise.