[RESOLVED] Need help with MSAccess vs. VB.NET

liunx

Guest
Take a look at this page ... <!-- m --><a class="postlink" href="http://elvenbelief.brinkster.net/admin.aspx">http://elvenbelief.brinkster.net/admin.aspx</a><!-- m -->

I'm trying to display the database name, then the table name, then some properties about the table columns. I've got the names working, but some things mess up when I get to the column properties.

If you look at the page, you'll see in the grey areas :
- The Column Name
- The Column DataType
- The Column AllowDBNull
- The Column AutoIncrement

But take a look at the ID column ... you'll see that
- AllowDBNull is TRUE
- AutoIncrement is FALSE

But when I view the database in MSAccess
- Required (NOT AllowDBNull) is TRUE
- AutoIncrement is TRUE

Anyone know why what the webpage and what MSAccess say don't match?
 
Top