Hi, Michael.
I've been importing image files to my database
successfully for some time without any problems
Storing images in an Access database causes database bloat, which will lead
to problems. It's better to store the image file on hard disk and store the
path and file name of this file in the database.
suddenly I've been getting an error message "Invalid
Argument" which Help says is error 3001. I now cannot
import image files, or select from pick lists on some, but
not all, records. I haven't changed the design of my form
or associated tables
Exactly how big is your database file? Access 2000, 2002, and 2003 can
store 2 GB of data, while Access 97 and older can store 1 GB of data. Once
the database is within about 96% of the maximum, bizarre things can happen,
seemingly for no reason. "Invalid argument" is one of those error messages
one gets when navigating through the database application, when this error
message never occured before.
Try compact/repair to see whether this reduces the size of the database
enough to be more manageable. Also, I would suggest changing the design of
your database application so that the images are stored externally to the
database.
HTH.
Gunny
See
http://www.QBuilt.com for all your database needs.
See
http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts, so that all
may benefit by filtering on "Answered questions" and quickly finding the
right answers to similar questions. Remember that the best answers are often
given to those who have a history of rewarding the contributors who have
taken the time to answer questions correctly.