I have imported 100s of other individual shapefiles into many other personal database files, but I have one shapefile that will not import properly. ArcMap will import the file, but it does not appear the same. This is a fairly large shapefile (114 MB) and the mdb file is nearly 2GB.
Solved! Go to Solution.
Absolutely a size problem as Dan Patterson mentions:
Because they are stored in Access databases, personal geodatabases have a maximum size of 2 GB
You should really consider moving away from Personal Geodatabases. Even if you are still not touching the limits, performance is really bad when a PGDB gets more than ½ -1 GB:
The effective limit before performance degrades is typically between 250 and 500 MB per Access database file.
.mdb files also do not delete records from tables (this is for performance reasons) when you delete or change records, rows are just marked as deleted. You can remove these ghost records (and sometimes dramatically improve the performance of an .mdb) by running a Compact on the database.
Having imported the shapefile into a file geodatabase, I find that 69 out of 370,051 attribute table records did NOT import with the rest. I am stymied as to why this happened, without any error or notification. Help??? Thank you all.
It is strange that there is not error message when not all the records are imported. Could you run a Check Geometry—Help | ArcGIS Desktop on the shapefile to see if there are any records that have error which may have prevented them from being imported? Since you have a large input file, it could take some time to run.