How to locate a new plug and play falsh drive's name?

[Niroth]

Here's my situation:

I have two work stations which I can't connect by a network, location too far apart, internet's not an option currently, but I want to share the data that's entered at the factory with the users at the office. I'm thinking of extracting the back end copy of my database from the factory at the end of the day, save it in a flash drive, and then replug the flash drive into the computer at the office, and tranfers the records into that copy of the database, every day. The problem is the flash drive's letter designation changes from computer to computer. Is there a way for me to store a copy of the access prgogramme that I use for the extraction in the flash drive inself, find the name of the flashdrive in which I need to safe the back end, and if possible starts the programme automatically once the flash drive is plugged in (if I can't start it automatically, then I'll just have to teach them to start it menually)? It seems a lot of to ask, so I'll appreciate any help. And if anyone has a better idea, please point it out to me cause what I'm thinking about seems unwieldy and unsafe, but that's the only solution I have so far.

Cheers.

 

[Atomic Shrimp]

Your best bet is probably to assign a persistent drive letter to the flash drive on each machine.

Instructions are here:
http://support.microsoft.com/kb/307844

 

[Niroth]

Thanks alot Mike. Looking into it. Seems like it might do the job.

Does anyone know of any VB code or method to initialise a programme from window when the flash drive is plugged in?

 

[rainman89]

You can manipulate the autorun file in the flashdrive to call a certain program.

 

[HiTechCoach]

This may help:

API: Enumerating Local and Network Drives

 

[Niroth]

You can manipulate the autorun file in the flashdrive to call a certain program.

Tried that. I thought it might be the .inf file that is stored in the flash drive, but it won't save any changes that I make to the file. Perhaps it's locked or something, and someone knows a way to unlock it? What kind of programme do people use for the kind of automatic start ups in set up CD-ROMs?

Thanks HTC, looking through it.

 

[rainman89]

That is the file. Autorun.inf

What if you open the file. copy it to your desktop or something then edit it and copy it back to the flash drive. does it work that way?