If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Primary Key/Read only issue
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 |
#2
|
|||
|
|||
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. Does anyone know how I can get around this? 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.) "Steve S" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |
Fixing up structure with primary, natural, surrogate, etc. | Fred Boer | Database Design | 11 | September 17th, 2004 05:53 PM |
Primary Key not sorted | Mike | Database Design | 6 | June 16th, 2004 11:11 PM |
Muliple primary key | Billy K | Database Design | 4 | May 31st, 2004 02:50 PM |