data not entered into mdb

[Guest]

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

 

[Joseph Meehan]

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

How large is the database file? Depending on the version there is a
max of 1 pr 2 gig. That's a lot, but if you have images mixed in there you
might be that large.

So if I understand you, you are saying that if you remove records it
will accept new records without running compact?

That would be strange as those records are not really removed until you
do a compact.

Is there anything in the code or other restrictions that might limit the
size of the table.

What is this script? Where is it getting the records?

Are any of the fields marked for no duplicates and would the new records
create a duplicate in one of those fields?

 

[Guest]

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

 

[Joseph Meehan]

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

Maybe someone who knows will steep in here. I seem to recall some
issues with running 2000 files in 2003 Access. I seem to recall that
converting it resolved the problems, but it may have required some special
conversion techniques.