data not entered into mdb

F

Flee

Hello,
I have a table of 30,000+ records in it. We have a script that reads in
info and then writes the info into the table. New info will not get added to
the table. Tried repair and compact without success. If we remove records
from the table, then new information will be added.

What am I missing here?

Thanks
 
F

Fred Lee

Hi Joseph,

The database file is only 7MB. We are using Access 2003 but the mdb file is
in 2000 format. The information in the tables is all text. There are no
pictures or anything like that.

The home-grown script takes subject line information contained in Outlook
emails and then populates that data into the table. I don't see anything in
the code of the script that will limit the table size.

We do have a field in the table marked for no duplcates but that information
is out of the control of the script. We have another server that send the
emails to Outlook.

I appreciate your time and help.

Fred
 
Top