SQL Server/VB (Identity Column) 
Author Message
 SQL Server/VB (Identity Column)

I've created a table in SQL Server with only 2 columns:
        test_id         int     NOT NULL
        test_name       char    NULL

And I set the test_id to be Identity and the Primary Key..  I'm able
to access the table, add new columns, and view the information with
Access.  But when I go into Visual Basic, I can't look at the table at
all.. the error I'm getting has no message, just an empty message box.


(a few minutes later, after calming down)

Any help on this is greatly appreciated.

Thanks in advance,
        Ron (the village idiot)

Fri, 12 Feb 1999 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Reset Identity Column in SQL Server table with VB

2. VB 4.0 & SQL Server 6.5 (Identity Column)

3. SQL SERVER + IDENTITY column + DbSeeChanges PROBLEM

4. Run time error 3622: OpenRecordSet: SQL server table: IDENTITY column

5. RDO, SQL Server and IDENTITY columns

6. Getting Identity column in SQL Server

7. SQL Server AddNew Identity Column

8. ADO 2.0, SQL Server 7.0, ServerSide cursors, IDENTITY columns after rs.AddNew

9. Programatically drop IDENTITY column in SQL Server?

10. RDO: Connecting to SQL server table containing an identity column

11. SQL PK Identity column problem with VB Update command

12. OpenRecordset and SQL Table w/ IDENTITY Column


Powered by phpBB® Forum Software