Acess Problem

  • Thread starter Thread starter PeteEHP
  • Start date Start date
P

PeteEHP

I have acess 2000 and im trying to import records from a text file.
import 5 records with the auto number function works fine. Then when
try to import 5 more records it gives me this error
Microsot acess was unable to append all data to the table. Why is thi
happening and is their a way around this? I need the autoo numbe
function to work to keep track of my records?
Thank
 
It would be helpful to provide some sample records, so that we can see the data you are
attempting to import. A table structure (fieldnames and datatype) would also be helpful.
Do you have a unique index (Indexed: Yes-->No Duplicates) on any of the fields? If so,
you may be attempting to import a value into a field that would be a duplicate to what was
already imported.

_________________________________________


I have acess 2000 and im trying to import records from a text file. i
import 5 records with the auto number function works fine. Then when i
try to import 5 more records it gives me this error
Microsot acess was unable to append all data to the table. Why is this
happening and is their a way around this? I need the autoo number
function to work to keep track of my records?
Thanks
 
Back
Top