doesn't show table fields ?

plz help me i am working asp with msacces. how to display all the colums in the table in asp. if i put following query "show membertable.colums" it doesn't display.

 

I am not getting you. Will you please explain it in details so that we can help you.

 

I don't know exactly what you are trying to do, but the script below will show all of the columns in the [Customers] table in the Northwind database:

<%
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
conn.Open ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\databases\northwind.mdb;")
rs.Open "SELECT * FROM [Customers]", conn
For Each x In rs.Fields
  Response.Write(x.Name & "<br>")
Next
rs.Close
conn.Close
Set rs = Nothing
Set conn = Nothing
%>

Code (markup):

Try that code. That should help

 

yes above script working. I need what you done in the above post. thank you. Now working fine. .