Hi, A question about: - Visual basic 6 - MDAC on Windows 2000 Prof Starting with Visual Basic 6: I'm making an application (just to learn how to do things in vb6) that gets data from a .mdb database. What is the best, common way to get the data out of the mdb file using visual basic 6 ? MDAC on Windows 2000 Prof: That same application has got to work proper on a windows 2000 prof machine, so what files should i use. Is there any need to install ms acces on that machine? What is the standard MDAC version on a windows 2000 prof computer? (The app is made on a W98 computer) I hope somebody can help me.. REGARDS, Merijn --- I don't live to work, I work to live ---

In case no one posts a more detailed response, this may be a little bit of help to you... Probably the easiest way to get started with database applications would be to use the ADO Data Control. I can't speak to any performance differences which may exist between using the control and doing everything through code. To use the application on another machine, there isn't any need to install Access. However, you may have to install the MDAC components separately to get it to work. You can download the MDAC setup here. If you're using an installer to put the program on another machine, you may be able to have the necessary files included in the setup so that the separate MDAC install isn't necessary (I know InstallShield will let you do this).

I agree with HiJinx on ADO Data Control. I use VB6 Packaging for installation on other systems. That way I am sure to have all the files necessary to the successful processing.I like to have Access installed on the other machine (usually it is already there since they are probably using Office Suite) in case it is necessary to work directly with the database. Also, I have to go in from time to time with PCAnywhere and it is nice to have Access available. Luck.

Wow, thanx to all responses, Madman, about the installer that ships with visual basic (package and deploiment) that one doesn't work on the windows 2000 prof operating system :( Maby somebody can explain why not?