Hello,

I like to know if you can retreive column information like
datatype, default_value etc. from Access.

The reason why I want to do this, is that I generate insert and update statements with Vbscript. I need the datatype of the columns to determine if I need to put qoutes around values (in the case of text) or not (in the case of number). In the case of a autonumber datatype, I want the value to be ignored.

I am using Vbscript on IIS to build a dynamic website. I
used to work with Oracle and I could retreive column
information from the datadictionary using SQL e.g.

select column_name
, data_type
from all_columns

How does this work in Access

I suppose you use ADO or DAO. Can anybody tell me which model to use and how to use it to retreive column information?

an example would be nice

Thanx in advance

Holke
..

Hi Holke,

if you use VB try that one

dim rst
set rst = createobject("ADODB.RECORDSET") 'any version

rst.Open "KundeVertr", strconn

For Each x In rst.Fields
Debug.Print x.Type 'will return a integer which describes a DataTypeEnum fron ADOBD
Next

Hope that helps