> Hi.
>
> I have an application that needs to update a database, as I'm using vb net
> and an access database I have to do this using ADOX.  I don't think there
> is
> another way.
>
> I have found all sorts of examples which are basically the same, but none
> of
> them work!
>
> I can create my tables and fields without any problems at all, but I want
> to
> create an AutoNumber field.  All the examples state something like,
> fld.properties("Autoincrement")=true.  Vb net tells me that the 'Item' is
> read only, I can't find anything else that helps.
>
> Anyone come across this?  Or have an answer?
>
> Cheers,
> Tull.
>
>

"Patrice" <scr***@chez.com> wrote in message
news:uamGUDswGHA.2260@TK2MSFTNGP03.phx.gbl...
> Try :
>
> fld.Properties("AutoIncrement").Value=True
>
> as fld.Properties("AutoIncrement") returns an object, not a boolean and
> you don"t have any more non indexed default properties in VB.NET....
>
> My personal preference would be likely to use SQL statements whenever
> possible...
>
> --
> Patrice
>
> "T Clancey" <t***@idcodeware.co.uk> a écrit dans le message de news:
> 69KdnQp_6KZWMXjZRVn***@bt.com...
>> Hi.
>>
>> I have an application that needs to update a database, as I'm using vb
>> net
>> and an access database I have to do this using ADOX.  I don't think there
>> is
>> another way.
>>
>> I have found all sorts of examples which are basically the same, but none
>> of
>> them work!
>>
>> I can create my tables and fields without any problems at all, but I want
>> to
>> create an AutoNumber field.  All the examples state something like,
>> fld.properties("Autoincrement")=true.  Vb net tells me that the 'Item' is
>> read only, I can't find anything else that helps.
>>
>> Anyone come across this?  Or have an answer?
>>
>> Cheers,
>> Tull.
>>
>>
>
>

"T Clancey" wrote:

> Would be nice, but as far as I know the Jet engine doesn't cater for table
> or field updates to Access.
>
> I'll give what you suggest a try.
>
> Cheers,
> Tull.
>
> "Patrice" <scr***@chez.com> wrote in message
> news:uamGUDswGHA.2260@TK2MSFTNGP03.phx.gbl...
> > Try :
> >
> > fld.Properties("AutoIncrement").Value=True
> >
> > as fld.Properties("AutoIncrement") returns an object, not a boolean and
> > you don"t have any more non indexed default properties in VB.NET....
> >
> > My personal preference would be likely to use SQL statements whenever
> > possible...
> >
> > --
> > Patrice
> >
> > "T Clancey" <t***@idcodeware.co.uk> a écrit dans le message de news:
> > 69KdnQp_6KZWMXjZRVn***@bt.com...
> >> Hi.
> >>
> >> I have an application that needs to update a database, as I'm using vb
> >> net
> >> and an access database I have to do this using ADOX.  I don't think there
> >> is
> >> another way.
> >>
> >> I have found all sorts of examples which are basically the same, but none
> >> of
> >> them work!
> >>
> >> I can create my tables and fields without any problems at all, but I want
> >> to
> >> create an AutoNumber field.  All the examples state something like,
> >> fld.properties("Autoincrement")=true.  Vb net tells me that the 'Item' is
> >> read only, I can't find anything else that helps.
> >>
> >> Anyone come across this?  Or have an answer?
> >>
> >> Cheers,
> >> Tull.
> >>
> >>
> >
> >
>
>
>

> Hi.
>
> I have an application that needs to update a database, as I'm using vb net
> and an access database I have to do this using ADOX.  I don't think there is
> another way.
>
> I have found all sorts of examples which are basically the same, but none of
> them work!
>
> I can create my tables and fields without any problems at all, but I want to
> create an AutoNumber field.  All the examples state something like,
> fld.properties("Autoincrement")=true.  Vb net tells me that the 'Item' is
> read only, I can't find anything else that helps.
>
> Anyone come across this?  Or have an answer?
>
> Cheers,
> Tull.

> On Fri, 18 Aug 2006 13:04:55 +0100, "T Clancey"
> <t***@idcodeware.co.uk> wrote:
>
> ¤ Hi.
> ¤
> ¤ I have an application that needs to update a database, as I'm using
> vb net
> ¤ and an access database I have to do this using ADOX.  I don't think
> there is
> ¤ another way.
> ¤
> ¤ I have found all sorts of examples which are basically the same, but
> none of
> ¤ them work!
> ¤
> ¤ I can create my tables and fields without any problems at all, but I
> want to
> ¤ create an AutoNumber field.  All the examples state something like,
> ¤ fld.properties("Autoincrement")=true.  Vb net tells me that the
> 'Item' is
> ¤ read only, I can't find anything else that helps.
> ¤
> ¤ Anyone come across this?  Or have an answer?
> ALTER TABLE TABLE_1 ADD COLUMN [ID] COUNTER
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)

"GhostInAK" wrote:

> Hello Paul,
>
> I'm not positive, but I believe last time I checked (admittedly a long time
> ago) Jet didn't support the ALTER keyword. 
>
> To the OP:  If this is an app you are giving to other people, not just something
> you use yourself, then I would strongly suggest using MSDE, Sql 2005 Express
> (or Pro), or the new SQL Everywhere (it's true.. SQL is even commin out my
> ears)..  You'll be kickin yourself as time goes on if you stick with Access.
>
> -Boo
>
> > On Fri, 18 Aug 2006 13:04:55 +0100, "T Clancey"
> > <t***@idcodeware.co.uk> wrote:
> >
> > ¤ Hi.
> > ¤
> > ¤ I have an application that needs to update a database, as I'm using
> > vb net
> > ¤ and an access database I have to do this using ADOX.  I don't think
> > there is
> > ¤ another way.
> > ¤
> > ¤ I have found all sorts of examples which are basically the same, but
> > none of
> > ¤ them work!
> > ¤
> > ¤ I can create my tables and fields without any problems at all, but I
> > want to
> > ¤ create an AutoNumber field.  All the examples state something like,
> > ¤ fld.properties("Autoincrement")=true.  Vb net tells me that the
> > 'Item' is
> > ¤ read only, I can't find anything else that helps.
> > ¤
> > ¤ Anyone come across this?  Or have an answer?
> > ALTER TABLE TABLE_1 ADD COLUMN [ID] COUNTER
> >
> > Paul
> > ~~~~
> > Microsoft MVP (Visual Basic)
>
>
>