Identity on Database Fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When you create a database how do you turn the identity off? Everytime I get
to the building of the array in VBA to pass information into my to pass to my
SQL table I get the error message "Identity cannot be determined for newly
inserted rows" and when I check my table I find null values in all the
fields. How can I eliminate this problem or ?? I know that data that I want
to add to the database is filling the array as when I hover over the
variables I see the information from the spreadsheet.

Any ideas will be appreciated.
 
NormaD said:
When you create a database how do you turn the identity off? Everytime I get
to the building of the array in VBA to pass information into my to pass to my
SQL table I get the error message "Identity cannot be determined for newly
inserted rows" and when I check my table I find null values in all the
fields. How can I eliminate this problem or ?? I know that data that I want
to add to the database is filling the array as when I hover over the
variables I see the information from the spreadsheet.

Any ideas will be appreciated.
Click to expand...

You could post some of your code.

Are you using client side or server side cursor?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Increment Field or Identity Field In MS SQL Server 0
Insert data into SQL Server db - find out the record number 6
Functions that return arrays 5
Runtime error 9 subscript out of range - assigning array to variable 0
Array by getrows to listbox - date format problem 0
Query two identical tables without combining 4
How to setup database to make transactions (transfers) between two bank accounts 0
Creating and Appending to Access dB using VBA 1

Back
Top