PC Review

Thread Tools Rate Thread

Re: ADOX Created Table Insert Problem

Mary Chipman [MSFT]
Posts: n/a
      22nd Sep 2009
You'll get a better range of responses on the Access newsgroups on
microsoft.public.access -- this one is devoted to .NET.


On Mon, 21 Sep 2009 15:37:21 -0400, SnapDive
<(E-Mail Removed)> wrote:

>Using ADOX 6 library reference in my C# 3.5 app. I create a Jet
>database and then a table with a primary key index like this:
>Index myindex = new Index();
>myindex .Name = "mytable";
>myindex .Unique = true;
>myindex .PrimaryKey = true;
>myindex .Columns.Append( "rowid" , DataTypeEnum.adInteger , 4 );
>It creates fine. WHen I try to insert with oledb like this:
>Insert Into RawData ( cola,colb ) Values ( ? , ? )
>and I get an error talking about the "rowid" column. I am not
>specifying it so it will autoincrement, but Access does not like that.
>Do I need to change the insert statement or the ADOX creation part?

Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Closing Access file created with ADOX.CatalogClass VMI Microsoft C# .NET 6 16th Mar 2013 09:33 PM
Deletion of views created via ADOX =?Utf-8?B?U3lzQWNjb3VudGFudA==?= Microsoft Access 4 26th Sep 2006 02:40 PM
ADOX performance problem: first attempt to read value from open ADOX catalog lasts long time lampi Microsoft Access 0 28th Apr 2005 01:21 PM
Error Creating Table in ADOX Wayne Wengert Microsoft VB .NET 5 20th Aug 2004 06:38 PM
Problem opening tables created using ADOX Jon Jeffery Microsoft Access ADP SQL Server 1 8th Jan 2004 07:22 PM




All times are GMT +1. The time now is 03:25 PM.