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.

 All Forums
 Other Forums
 MS Access
 MS Access ADP/Sql server 7 problem

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,647

Are you planning to go above that????

Jim
Users <> Logic
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -