I have a CD-ROM that has an MS Access 2.0 file on it that's at least 6 years old. The guy who I purchased the product from promised updates, but never followed through, despite numerous letters requesting that he honor his word. I then tossed it into a storage tray and forgot about it until late last fall, when I found it while I was packing for a move which unfortunately didn't occur. I've been trying to get at the data so that I can import it into my own database file without success. I know that there are numerous password retrieval programs out on the Internet, but the wife gets all of the credit card bills and would have a cow over my buying software while supporting 2 households (my home and my apartment in the city where I work). So I've written a brute force password creator program in VB and run it on the machine Darryl Spice built for me or on the work machine when I go home every evening. The program creates a string of 8 ASCII characters and increments the string values by one after every unsuccessful attempt.
That was the plan. The reality is whenever I run it, when the code hits the "Open" statement, up pops the "Select Data Source" box requesting that I pick a DSN linked to the Access 2.0 file which I copied down to the hard drive. Naturally, since I don't have permission/rights to the file, I can't create a DSN connected to the file. So I can hit the "Cancel" button so the program will move onto the next string variation of a password, but the "Select Data Source" box keeps coming up. This happens on the work machine that has NT 4.0 and my home machines that have Win98 original.
Any suggestions on how to prevent the "Select Data Source" box from popping up so the program can run unattended?