Linking tables to Access Front end

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Friel (Friel.1h9b9k_at_mail.webservertalk.com)
Date: 12/14/04 

Date: Tue, 14 Dec 2004 07:20:46 -0600

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

Relevant Pages

  • Re: Multi-Field Primary Key
    ... I.E. the worst arrangement is to have the autonumber alone be the ... Such a key could implemented using a UNIQUE constraint i.e. ... you are a fan of the 'CASCADE to null' feature in Jet 4.0 ). ... SQL Server will disregard all values in the referencing columns if one ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Two Tables Insert Into with Select @@ Identity
    ... If you're using SQL Server ... INSERT commands - you can't enter values into an AutoNumber column w/o ... If you're using straight JET you can use VBA to open a Recordset to ... ' Run the 2nd INSERT INTO command. ...
    (microsoft.public.access.queries)
  • Re: Two Tables Insert Into with Select @@ Identity
    ... If you're using SQL Server ... INSERT commands - you can't enter values into an AutoNumber column w/o ... ' Run the 2nd INSERT INTO command. ... if field2 was a string: ...
    (microsoft.public.access.queries)
  • Re: Two Tables Insert Into with Select @@ Identity
    ... Charset: noconv ... If you're using SQL Server ... INSERT commands - you can't enter values into an AutoNumber column w/o ... ' Run the 2nd INSERT INTO command. ...
    (microsoft.public.access.queries)
  • Re: Renumbering MS db ID?
    ... I'm not an Access user, but as far as the notion that 'there is no need to ... MS Access or MS SQL Server? ... There is no need to care what the ... > guarrantees that and it is the only purpose autonumber is used for. ...
    (microsoft.public.dotnet.framework.adonet)