Re: Linking tables to Access Front end

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: User (User_at_aol.com)
Date: 12/14/04

  • Next message: Notre compte nouveau compte FREE: "SQLServer 2000 from unix solaris 2.8 server" 
    Date: Tue, 14 Dec 2004 11:57:32 -0800

    The SQL version of autonumber is IDENTITY not UNIQUE IDENTIFIER.

    "Friel" <Friel.1h9b9k@mail.webservertalk.com> wrote in message
    news:Friel.1h9b9k@mail.webservertalk.com...
    >
    > I have been given the task of converting an access database back end to
    > an sql server back end and then linking these tables to the access
    > front end.
    >
    > Exporting the back end tables to SQL server was fine, however there is
    > a problem with the autonumber field on a table. This field was exported
    > correctly, SQL server has this field as a unique identifier.
    > However when I link this table to the front end and open the table in
    > design view, it sees this field as a number field, not an autonumber
    > field so when values are inserted from a form into the table, it doesnt
    > generate a number for this field and therefore the insert receives an
    > error along the lines of 'cannot insert nulls into this field'
    >
    > How can I link this table into the access front end so the front end
    > correctly recognizes this field as autonumber and performs the insert
    > correctly?
    >
    >
    >
    > --
    > Friel
    > ------------------------------------------------------------------------
    > Posted via http://www.webservertalk.com
    > ------------------------------------------------------------------------
    > View this thread: http://www.webservertalk.com/message635787.html
    >

  • Next message: Notre compte nouveau compte FREE: "SQLServer 2000 from unix solaris 2.8 server"

    Relevant Pages

    • Re: Linking tables to Access Front end
      ... The SQL version of autonumber is IDENTITY not UNIQUE IDENTIFIER. ... > Exporting the back end tables to SQL server was fine, ...
      (microsoft.public.sqlserver.odbc)
    • Re: programatically add table in access
      ... In SQL Server you can default a guid datatype with a newGUIDbuiltin function, but check the documentation for Access. ... Autonumber is a field attribute, as is the format property which you would use to set the displayed decimal places. ...
      (microsoft.public.dotnet.languages.csharp)
    • Re: Transformation from Dbase III
      ... Does Dbase III have autonumber? ... If you want to simply transfer those attributes from dBase III and have SQL ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
      (microsoft.public.sqlserver.dts)
    • Re: Write conflict
      ... unique identifier but I still need to add a timestamp field? ... >> I added two new fields to a SQL table and updated the SQL view that the ... > Presumably by SQL you mean SQL Server. ...
      (microsoft.public.access.queries)
    • Re: Unique Number for each row
      ... An AutoNumber is really ... via a Query or SQL statement. ... ORDER BY clause returning the data in the same order every time. ... retrieving or navigating the entire table. ...
      (comp.databases.ms-access)