how to access MS-Access -Query through vb coding

[mukeshsrivastav]

Dear All,

I have developed one my complete full functional application.usi ng MS_ACCESS -table and vb6 adodc connection.

Can a Ms-access Query be access form vb6 coding .if yes can you provide me the syntax for accessing it.

Thanking All

With Regard

Mukesh Srivastava

[Killer42]

I have developed one my complete full functional application.usi ng MS_ACCESS -table and vb6 adodc connection.

Can a Ms-access Query be access form vb6 coding .if yes can you provide me the syntax for accessing it.

Can you give us an idea of how far you have gone with the adodc thing?

Using a query is just like using a table - just specify the query name as though it were the name of a table.

[mukeshsrivastav]

Can you give us an idea of how far you have gone with the adodc thing?

Using a query is just like using a table - just specify the query name as though it were the name of a table.

Dear Sir,
my application is about student registration in our institute, right now I have 8 forms accessing database.includ ing all DML operation. I want to have my application operate like oracle database. what I think Ms-Access Query is like View in oracle .
That's why I m asking u use of query over my application.

Actually when we make connection manual not through coding .in record source
Only three type record source first is 'actable',but I haven't seen query,in that list

and I also want to know from u can a MS-access database be used over web.

Thanking you.

Mukesh