General discussion

Locked

Access overwriting records

By Blackcurrant ·
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

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access overwriting records

by david.wilkinson In reply to Access overwriting record ...

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

Collapse -

Access overwriting records

by Blackcurrant In reply to Access overwriting record ...

Hi, Thanks for answering. A primary key exists.

Collapse -

Access overwriting records

by kees.valkenswaard In reply to Access overwriting record ...

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.

Collapse -

Access overwriting records

by Blackcurrant In reply to Access overwriting record ...

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.

Collapse -

Access overwriting records

by Blackcurrant In reply to Access overwriting record ...

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums