Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
redbox333
Starting Member
2 Posts |
 Posted - 2005-01-21 : 12:25:39
|
| I just finished making an adp connection to an sql server 7 database, and then proceeded to make the tables from the acess interface. I then set up one column as a primary key and gave it a data type of int. My problem is that my length value is only 4 (this is an identity column with an identity seed of 1 and an identity increment of 1), and I can't seem to be able to change this value any higher.My concern is what will happen once this column reaches the full length value (of 9999)? And is there a way to increase this value? |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-01-21 : 13:13:41
|
| 4 bytes max value = 2,147,483,647Are you planning to go above that????JimUsers <> Logic |
 |
|
|
redbox333
Starting Member
2 Posts |
Posted - 2005-01-21 : 13:34:02
|
| Sorry - thought it was number size (xxxx), not bytes. Thanks for clearing that up for me |
|
|
|
|
|
|
MS Access ADP/Sql server 7 problem