A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

IN ACCESS ERROR 3001 HOW TO RESOLVE



 
 
Thread Tools Display Modes
  #1  
Old February 22nd, 2006, 11:58 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default IN ACCESS ERROR 3001 HOW TO RESOLVE

trying to OLE photos into Access field up til recently no problem suddenly
now refuses to accept stating Error 3001 Invalid Argument
Tried help within programme still not resolved please advise
  #2  
Old February 23rd, 2006, 11:00 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default IN ACCESS ERROR 3001 HOW TO RESOLVE



How big is your mdb file?

Using OLE Embedding or Linking is extremely inefficient with compressed images such as JPEG - there can
be an overhead of up to 200 *times* the original file size. Access has a file size limit of 2 GB, and
when you get close to this limit you can experience various errors, including the one you mention.

If this is the problem then you should either switch to raw binary storage, which has no storage overhead,
or use external image files.

--
__________________________________________________ _____
DBPix 2.0: Add pictures to Access, Easily & Efficiently
http://www.ammara.com/dbpix/access.html



"=?Utf-8?B?SnVsZXM=?=" wrote:
trying to OLE photos into Access field up til recently no problem suddenly
now refuses to accept stating Error 3001 Invalid Argument
Tried help within programme still not resolved please advise


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
2002 vs 2003 Patrick Stubbin General Discussion 2 May 17th, 2005 07:27 AM
The "Right" web hosting for data access pages?? Ron Ehrlich General Discussion 9 May 6th, 2005 05:49 AM
Why is a French Spellchecker a "required" update for English speak French Spellcheck Required? General Discussion 23 April 26th, 2005 01:17 AM
Encrypt AccesS File? milest General Discussion 2 February 9th, 2005 08:58 PM
Access Error Message when opening database eah General Discussion 3 January 26th, 2005 11:04 AM


All times are GMT +1. The time now is 11:37 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.