Records not added to MS Access db - why?

Hi,

I have a PHP script that pulls records from an MySQL database for users who have become a member the day before and then adds those records to an MS Access database. It runs once a night.

When this script runs, if a marker has been reset on all the records in the MS Access database, the script pulls the records for ALL the members from the MySQL database and adds them as new records to MS Access database.

This seems to have been working fine, but recently, I have two records that were not added the MS Access database, even though they were present in the query that selects the records to copy from the MySQL database to the MS Access database.

I don't believe this to be a problem with the script, but a problem with how MS Access processes queries. I was wondering if anyone had any insight or a reason as to why this happened? I would appreciate any help I can get on this.

Thanks!

Bump...

Anyone? This is still an outstanding issue for me.

Thanks!