This is a really strange one! I've got an import button written in VBA that reads in a CSV file to a temporary table and then appends the records to another table.
This works fine until I create an MDE file, when for some reason it seems to be trying to append double the number of records (the same ones twice), which results in violation errors.
Because I can't step through code in an MDE I'm a little stumped for what to do next! The database uses linked tables, but then so does the underlying MDB file and it works fine.
Anyone got any ideas? Help much Appreciated.
This works fine until I create an MDE file, when for some reason it seems to be trying to append double the number of records (the same ones twice), which results in violation errors.
Because I can't step through code in an MDE I'm a little stumped for what to do next! The database uses linked tables, but then so does the underlying MDB file and it works fine.
Anyone got any ideas? Help much Appreciated.