RE: Access-SQL Serv Autonumber

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: OrSomeThingLikeThat (revinfreddyfloyd_at_yahoo.com.(OrSomeThingLikeThat))
Date: 02/02/05 

Date: Wed, 2 Feb 2005 04:59:02 -0800

You need to set the datatype on the SQL Server to Int. Then check the
checkbox that says 'Identity' field in the Manage indexes dialog.

"Stuart" wrote:

> I have an Access database that was upsized. Access F/E, S2k back. I cannot
> update tables that I had to create an index for the upsize. All my queries
> come back with "cannot insert null" into index field. Access calls it
> Autonumber and we never have to do anything else.
>
> I'm gusssing there is a constraint problem ? Where should I start looking.
> Its a primary key field, unique, indenty=1. I thought that defined it as
> Autonumber.
>
> Help !

Relevant Pages

  • Re: Checkbox entry to new table
    ... The entry is then closed. ... original Autonumber to dump into its corresponding table (if the second user ... selects Adverse Event then that Autonumber will dump into the Adverse Event ... checkbox was checked. ...
    (microsoft.public.access.tablesdbdesign)
  • Rating system: Query to get a rate for each entry found.
    ... RID - Autonumber ... Value - Int ... The rate-table are filled with these entries (note value are a number ... query but I can't get it to work. ...
    (microsoft.public.access.queries)
  • Re: Rating system: Query to get a rate for each entry found.
    ... the countand sum() of values. ... MoviesTable so that yougetresults for ID=3. ... RID - Autonumber ... Value - Int ...
    (microsoft.public.access.queries)
  • Re: Rating system: Query to get a rate for each entry found.
    ... Paste this in using SQL View inQueryDesigner. ... RID - Autonumber ... Value - Int ...
    (microsoft.public.access.queries)
  • Re: Checkbox Null
    ... The second table holds a checkbox. ... are linked together by an AutoNumber. ... a Null for the boolean field. ... specify "Is Null" and an alternate criterion for the field, ...
    (microsoft.public.access.modulesdaovba)