Primary Key/Read only issue

  • Thread starter Thread starter Steve S
  • Start date Start date
S

Steve S

Hi:
I'm setting up a table in an ACCESS 2003 ADP project. I don't want to
assign a primary key because the data I'll be importing contains duplicate
values in all collumns. There is no, and can be no field with unique
values. When I import the data into this table I'm not able to add, delete,
edit data or do anything because I have no primary key defined. It tells me
that the recordset is not updatable and the data is read only. Does anyone
know how I can get around this?
Thanks in advance,
Steve
 
Hi, Steve.
When I import the data into this table I'm not able to add, delete,
edit data or do anything because I have no primary key defined.
Click to expand...
Does anyone
know how I can get around this?
Click to expand...

Yes. Add a new column to the table to hold a unique value to be created for
each record so that the database engine can uniquely identify each record in
the table. This new column will be used as the primary key for this
temporary table. The purpose of a primary key is to uniquely identify
records and establish relationships between records in multiple tables.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Back
Top