Opening a database file and running a query
Posted on 2001-07-27
I have a database file with several tables. I need to open the database from my vb 6 program and run a simple query using two tables from the database and store the result in vb.
DataBase = "H:\Access\NT\NT_Cat_dbs.mdb"
Table 1 = "Test Information"
Fields needed to get: TestNo & Phase
Table 2 = "Test Animals"
Fields needed to get: ProductID
I need to query the database using the fields:
If datatypes need declared please include code.
Ask for More info if needed or not clear.....