i have a general procedure in vb.in which a query to select values from specified table.the name of table is passed as an arguement from different forms to this general procedure.but the query is not like
select * from
it is like
select col1,col2,col3..... from table1.
is there any solution in MSAccess,as in oracle as
select * from tab -to get all table names.
select column_name from user_tab_columns -to get column names of a particular table.
if i could get the this,then i cloud pass them as string arguements.my task will get solved.
thanks for ur help