Import table (1 Viewer)

[IanT]

I am trying to import a table from an existing access data base. The table has the auto number set which currently runs from 1 to 926. But when I have imported this table the auto number, when entering a new record jumps to 1852 (Double the records), not 927!

Can anyone advise me why this is happening, and can I stop it!!!!

Thanks in advance.

 

[glynch]

I think you must have tried an import that didn't succeed part way through, but ended up "stealing" those autonumber values. Try deleting your local table and reimporting. If that doesn't work then import only the table structure, link to the remote table and do an append query into your new table.