Apr 26, 2004 #1 livvie Programmer Apr 20, 2004 91 IE What has replaced Auto Number in Data Types in Access Projects 2003 ?
Apr 26, 2004 #2 TimKThailand Programmer May 26, 2003 54 TH Use bigint or int and set Identity property of the field to YES. Upvote 0 Downvote
Apr 26, 2004 Thread starter #3 livvie Programmer Apr 20, 2004 91 IE Tried that but it doesn't create an automatic number ? Upvote 0 Downvote
Apr 26, 2004 #4 TimKThailand Programmer May 26, 2003 54 TH Yes, I use Identity (or AutoNumber) in SQL Server and it works. Have you tried adding records in? Upvote 0 Downvote
Apr 27, 2004 Thread starter #5 livvie Programmer Apr 20, 2004 91 IE It works if you use it from th start I was trying to chnage a field and it wouldn't work. Thanks a million Upvote 0 Downvote
It works if you use it from th start I was trying to chnage a field and it wouldn't work. Thanks a million