i have another database question

[Leeper77]

Ok as some of you know i have a program that accesses 3 db 2 inventory and 1 personal inventory what i would like to know is if you can access the 3 databases from 1 data control or not? Or do i have to code it into the program?

Any Ideas

Thanks

[chrisjk]

Try using an ADO control instead. Somehow in the select statement you are able to specify multiple databases (I am lead to believe you can anyway).

To keep it simple I would have 3 separate controls, but that's just me.

Regards,

------------------
- Chris
chris.kilhams@btinternet.com
If it ain't broke - don't fix it :)

[Leeper77]

how do you go about doing that? I am used to the data controls as well

[danix]

I'm afraid you will have to use code. The best way is probably using SQL...eg
SELECT whatever FROM tablename WHERE whatyouwant = "string"
You can do this for as many different tables or db's as needed.

------------------