Field attributes in Access, Set object problem, Autonumber.

[JonMa]

Hello all helpers.
I am trying to find out which attributes a field have in any database, so I can avoid insert on that field.
However I do not know how to connect to a tabledef object in vbscript. The code below will not work because of the line "Set tdf = db.TableDefs("Person&quot".
Is there some connection missing to an object and how can I do it?

Set db = CreateObject("ADODB.Connection&quot
db.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=f:\asp\jon\Korps.mdb"

Set tdf = db.TableDefs("Person&quot
Set fld = tdf.Fields("KorpsID&quot
Msgbox fld.Attributes

Kindly Regards.

 

[spazman]

I don't think you can, I know SQL would do this.