Table will not accept new records

By tonyj6855 ·
I have a DB that I created approximately a year ago that includes a table that we used to store a graphic related to a specific customer product. The graphic is a jpg file that was inserted into a MS Word document then copied to the field from a form. Everything was fine until a couple of weeks ago when the users could no longer add records that included a picture to the table. If they try, it appears like everything is fine but when they go back into the form to look at the record nothing is there. You can not add a record to the table if you try to add the graphic to it. As far as I know, nothing has changed in the DB and there are a few hundred records that have similar graphics in them but now we can not add anymore.

Does anyone have any suggestions on how to remedy this problem?


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -


by LarryD4 In reply to Table will not accept new ...

If this is a MS_Access Database have you checked to see if your database has reached the maximum size for an Access DB?

Microsoft Access database specifications
Microsoft Access database (.mdb) file size 2 gigabytes minus the space needed for system objects.
Number of objects in a database 32,768
Modules (including forms and reports with the HasModule property set to True) 1,000
Number of characters in an object name 64
Number of characters in a password 14
Number of characters in a user name or group name 20
Number of concurrent users 255

Related Discussions

Related Forums