Unknown record in table with autonumber

  • Thread starter Thread starter Matt Pinto
  • Start date Start date
M

Matt Pinto

Hi folks,

We have an Access 2000 database, containing a table with
an Autonumber field.

User reported seeing an error whilst updating records in
this table, but can't remember what it was.

Having examined the table, there is a record in the table
with no data in the fields, even the Autonumber field.
Having tried to delete it, Access returns an relating to
the index, presumably because there is nothing in the
Autonumber field.
Does anyone know of any way of removing this record, as it
is causing all sorts of other problems with reports etc? I
can't change the field from Autonumber to something else,
because I wont be able to change it back to Autonumber.

I haven't tried a compact and repair yet, as the backup
won't take place until tonight (500Mb database).

Cheers,


Matt
 
Rather than changing the data type, which is tedious, try temporarily
deleting the index that's generating the error...but I must say that sounds
a little odd to me. Are you sure it's not a related-table thing?

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...
 
Hi Rebecca,

Thanks for that info. In the end I had a backup table
which I copied in, and then just copied the new records
keyed (minus the problem one) from the old table to the
new table.

I can only imagine the error the users got caused a
corruption in the table which resulted in this 'empty'
record.
However, if it happens again, I will try your suggestion,
which sounds a lot easier!

Many thanks,

Matt
 
Back
Top