Primary Key-Read/Write - Still Can't Figure It Out

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

Steve S

Hi:
I have an Access 2003 adp where I'm importing comma delimited text into a
temporary table.This table has no primary key in that all fields have
duplicate data, therefore I only have read access to the data and the
recordset is uneditable. That's o.k. in the temporary table, but once I
export it to a permanent table I need to define a primary key so I can edit,
add and delete data. This is where I'm stumped. When I export data to the
permanent table (which has a 'uniqueidentifier' field that represents the
primary key, I get a returned error message that says "unable to process
request because primary key can't contain Null values). The temporary table
dosn't have a uniqueidentifier field but the master does. How can I get to
master table to autimatically update uniqueidentifiers in that primary key
field upon export?
Thanks in advance,
Steve
 
How can I get to
master table to autimatically update uniqueidentifiers in that primary key
field upon export?
Click to expand...

Make it an Autonumber field; or write code to increment a value.

John W. Vinson[MVP]
 
Back
Top