PC Review


Reply
Thread Tools Rate Thread

Re: ADOX Created Table Insert Problem

 
 
Mary Chipman [MSFT]
Guest
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.

--Mary

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?
>
>Thanks.

 
Reply With Quote
 
 
 
Reply

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


Features
 

Advertising
 

Newsgroups
 


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