Table Problem

[Saifon]

hi

I have a multi purpose database for logging and recording various information. The more common function of the database is Call transfers to various departments.

I've noticed this happening more recently. At the beginning of the day it's fine, but towards the end of the day, it pops up with this error when trying to add records.

However all other aspects of the database work, I am able to add records into other tables.

I've tried to add records directly on the tables without the use of forms and the problem exists only on this one table.

If I copy the database to a different location and access it on my own, it works fine, and if I copy it back overwriting the previous one, it continues to function for another day.

Somehow.. possibly after so many entries.. it seems to lock the table from adding entries..

Any ideas all you database wizards..

 

[Len Boorman]

Sounds like a Record Locking problem. Check the record lock property of the form

Set it to Edited record Only

Just a place to start

Len B