Software

Ask something
Discussion Locked

Access overwriting records

0 helpful
5 replies

by blackcurrant

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi

My company has an Access database in which contact addresses are stored. The database has exceeded 5000 records and when new addresses are added, they overwrite older (different) ones. The database was set-up by a previous employee, and I cannot find a solution to this.

Is it possible to set a limit on the number of records that Access can create in a database? Is there an internal error that can create this problem?

Please help.

Thanks

5 replies

by david.wilkinson

Hi,

I assume that the database has a "primary key" on it ?

if not see if you are able to make an extra row in the table to put a primary key, and then see if it still overwrites ?

Dave

by kees.valkenswaard

Your situation is something unusual. I just created a database in access with over 100000 address records in it. I can easily add a new record. This works both in Access 98 and 2000. Perhaps there might be some macro added which sets a limit. Did you check all macros?
It may be good to look under tools, options if some objects are hidden.
Good luck.
If you would like to mail me, make certain to include Q&A in the subject line, else the message will be deleted.

by blackcurrant

Hi, thanks for answering. I have contacted the person who created the DB and they have no idea why records are being overwritten. No macro has been written limiting the No of records.

This discussion is closed to new replies.