access 2007 database stopped allowing new input

By coronacapital ·
I have made a database which worked well until recently. I opened it to add information and found that I couldn't add any new information to most of the forms. I have one form still letting me add new information. I have even tried the backup and it has the same problem. Can anyone suggest what I may have done or what could be the problem please.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Try a Compact and Repair

by Tony Hopkinson In reply to access 2007 database stop ...

Note if this is the issue you could lose some data, even gain some rubbish.

Access has known issues on this front, particulary if the mdb file is on a networked drive.

If it's critical stuff, either more regular backups (so you have one before access messes it up), or consider putting your data in sql server (Express is free) and then linking to it with access.


Related Discussions

Related Forums