Search results for query: *

How do I set the IsolationLevel of an oledb.olebdconnection ? please don't refer me to documentations, I've read them all. I need a code example. I'm using MS-ACCESS. Thanks.

I want to change a column in MS-ACCESS from char(22) to char(100) through code. I tried "ALTER TABLE <table name> MODIFY <column-name> char(100)" like ansi-SQL defines. Didn't work. Not through code and not even through MS-ACCESS itself. Ideas ?

Hi, As a result of version enhancments, I need to perform an upgrade to existing access DB. This upgrade involves adding a new column to an existing table. Tried ADOX and ADO.NET with no success ... Anyone knows how to do it ? Thanks, Doron.

Sorry , I should be more clear ... what I meant was how do I create Ms Access Queries through Code ... You can create queries inside Ms-Access in Design time. Actually it's just an SQL statement that is defined in Ms-Access so you won't have to create it again and again ( kind of view ) ...

How do I create Queries from code ?

I'm going through hell trying to create a new access database with one table in it. I have tried each and every code example I ran into. ADOX , ADO , ADO.NET , you name it. Nothing is working. Each sample with it's own problems. Can anyone please write the minimal code needed to create a...

Any idea why System.Type.GetType("System.Int32") returns nothing ? ANY type I use acts the same. I took samples from everywhere in the glob. Always ending getting null .

yes .. Well , I first need to create a new mdb file. From what I know the only way to do this is using ADOX. Then I want to create a table and indexes and add some rows. I know I can just "CREATE TABLE .... " sing OleDBCommand but I rather not to. I tried messing around with...

ADOX enum ain't working Why can't I define adBig Int or other types when creating a table ??? adInteger works .. I get invalid type ... Dim ADOXtable As New ADOX.Table 'name table, append fields to table ADOXtable.Name = "bla" ADOXtable.Columns.Append("sort"...