Click to See Complete Forum and Search --> : Running Access Queries in VB


Salvation
March 8th, 2000, 09:07 AM
Ok, I'm having the following problem: I need to write a program/form in VB that is able to run Access Queries that exist in a certain Access Database. I can run the queries under Access, but those queries have to communicate with a filebrowser because they need a certain path. I work with Visual Basic 6 Enterprise Edition and Microsoft Access 97. Access 97 does not support, at least as far as I know, the drivelistbox-,dirlistbox- and filelistbox-controls.
Please let me know if you can help,

thx

Salvation

March 16th, 2000, 01:52 PM
Let me get this right. You want to run a query whos recordsource is from a different Database?

If that is so, in the query design, if you look at the properties for the query you will see an option there that says source database. You can enter the source you want there.