Re: DDL-Adding Autonumber limit

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

On Jun 1, 3:33 am, "'69 Camaro" <ForwardZERO_SPAM.To.
69Cam...@xxxxxxxxxxxxxxxxxxxxxx> wrote:
Hi, Chris.



I'm trying to add a PK to a newly imported text file.
. . .
Is there a way to force Access to go forward anyway?

Yes. You already have the import specification, so you know exactly what
the column names are, the data types, and the column sizes. Therefore,
import the text file into a pre-existing, empty table where you've already
added the ID column as the primary key. Each new record imported into the
existing table will have the ID column automatically incremented, so there's
no need to lock records while the Autonumber column and primary key
constraint are being added to the table later.

HTH.
Gunny

Seehttp://www.QBuilt.comfor all your database needs.
Seehttp://www.Access.QBuilt.comfor Microsoft Access tips and tutorials.
Blogs:www.DataDevilDog.BlogSpot.com,www.DatabaseTips.BlogSpot.comhttp://www.Access.QBuilt.com/html/expert_contributors2.htmlfor contact
info.

Sorry, I didn't say thank you sooner. This was a top notch solution.
Thanks!!!

Chris M.

.

Relevant Pages

  • Re: DDL-Adding Autonumber limit
    ... the column names are, the data types, and the column sizes. ... added the ID column as the primary key. ... See http://www.QBuilt.com for all your database needs. ...
    (microsoft.public.access.formscoding)
  • Re: Newbie Normalization Question
    ... Data types was an obvious and very stupid mistake - long day and late night makes for simpleton code. ... Could not create constraint. ... > (game_nbr INTEGER NOT NULL PRIMARY KEY, ... > Please post DDL, so that people do not have to guess what the keys, ...
    (microsoft.public.sqlserver.programming)
  • Re: Newbie Normalization Question
    ... let's get the right data types and fix the wrong names. ... "fk_" is a horrible violation of ISO-11179 rules and a good way to ... (game_nbr INTEGER NOT NULL PRIMARY KEY, ... Please post DDL, so that people do not have to guess what the keys, ...
    (microsoft.public.sqlserver.programming)
  • Re: Collecting data via an input form
    ... what's your table structure - as in, tablename, fieldnames and data types, ... primary key and foreign keys? ... I am inputing surveys on classes. ...
    (microsoft.public.access.forms)
  • Re: compare text files
    ... Thing is that I need to compare each record by the primary key ... (CodeNumber) ... always have the same number of fields with the same data types, ...
    (microsoft.public.vb.general.discussion)