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 |
|
token
Posting Yak Master
133 Posts |
 Posted - 2008-10-08 : 15:54:24
|
| I am making a front-end GUI for my SQL Server database using Access 2007 (I've abandoned InfoPath for now). One thing that is bugging me is that my ProductID field in SQL Server is a primary key with identity specification (autonumbering). But when I view this data through Access 2007, it does not show up in Form design. It wants me to enter a number for the ProductID field manually.Does anyone know a way around this? |
|
|
token
Posting Yak Master
133 Posts |
Posted - 2008-10-17 : 19:36:08
|
| I figured it out.... just leave the ID field blank and it will auto-insert a unique number for you.For anyone looking for a decent front-end to help with data entry, I cannot stress enough how good Access 2007 is. It is simple and so easy to make great forms with awesome functionality. |
 |
|
|
|
|
|
SQL Server IDENTITY SPEC in Access 2007!