Error with LoadFormFile

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Good afternoon! I use the library 16.12. When opening large files with a size from 500MB to 4 GB, the LoadFromFile function returns a 401 error. How to defeat it? How can I increase the available memory? It is required to edit files, direct access will not help here.

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Varvarkin Members Profile Find Members Posts Beginner Joined: 27 Jun 21 Location: Russia Status: Offline Points: 5	Post Options Post Reply Quote Varvarkin Report Post Thanks(0) Quote Reply Topic: Error with LoadFormFile Posted: 27 Jun 21 at 10:26AM
	Good afternoon! I use the library 16.12. When opening large files with a size from 500MB to 4 GB, the LoadFromFile function returns a 401 error. How to defeat it? How can I increase the available memory? It is required to edit files, direct access will not help here.

Ingo Members Profile Find Members Posts Moderator Group Joined: 29 Oct 05 Status: Offline Points: 3529	Post Options Post Reply Quote Ingo Report Post Thanks(0) Quote Reply Posted: 27 Jun 21 at 9:30PM
	Hi Alex, getting 401 seems to me that you've already used LastErrorCode directly after LoadFromFile? There's no real solution for this but a 4-gb-form isn't a solution as well ;-) Perhaps you can split the functionality of your process into several steps...? Reading the pdf-content into a stream and try the loadFromStream-function? Cheers and welcome here, Ingo
	Cheers, Ingo

Varvarkin Members Profile Find Members Posts Beginner Joined: 27 Jun 21 Location: Russia Status: Offline Points: 5	Post Options Post Reply Quote Varvarkin Report Post Thanks(0) Quote Reply Posted: 27 Jun 21 at 9:52PM
	Yes, the error occurs immediately after opening. Randomly, it can open a file in 600 MB and not open it in 300 MB. And a file is not a form, but a book in a printed version for the page layout. I was thinking how it is possible to work with such large files, for example, to divide, process in parts, but in any case it needs to be edited. And then connect it. But there are no such functions in direct access. Can you suggest a solution using LoadFromStream, how to do it, step by step?

tfrost Members Profile Find Members Posts Senior Member Joined: 06 Sep 10 Location: UK Status: Offline Points: 437	Post Options Post Reply Quote tfrost Report Post Thanks(0) Quote Reply Posted: 27 Jun 21 at 10:41PM
	What programming language are you using, and does it support 64-bit applications? With 32-bit you obviously cannot load such large files into memory all at once, either from a stream or direct. And some QPDF language interfaces do not have streams, either.

Varvarkin Members Profile Find Members Posts Beginner Joined: 27 Jun 21 Location: Russia Status: Offline Points: 5	Post Options Post Reply Quote Varvarkin Report Post Thanks(0) Quote Reply Posted: 28 Jun 21 at 7:35AM
	I use VBA (ActiveX) in MSAcesss

tfrost Members Profile Find Members Posts Senior Member Joined: 06 Sep 10 Location: UK Status: Offline Points: 437	Post Options Post Reply Quote tfrost Report Post Thanks(0) Quote Reply Posted: 28 Jun 21 at 11:22AM
	The QPDF ActiveX library has 32-bit and 64-bit versions, and there is unlikely to be a size limit affecting a 4GB PDF in a 64-bit process, if you have enough real and virtual memory. LoadFromStream is a Delphi-only API so not in the ActiveX library, but you should not need it if you can use 64-bit from VBA and Access. As far as I can recall Microsoft recommends installing 32-bit Office. But know almost nothing about VBA so maybe another user here can help you with that.

Varvarkin Members Profile Find Members Posts Beginner Joined: 27 Jun 21 Location: Russia Status: Offline Points: 5	Post Options Post Reply Quote Varvarkin Report Post Thanks(0) Quote Reply Posted: 28 Jun 21 at 8:33PM
	I just tried to work on the 64-bit version, the result is the same. 2,23 Gb filesize. Clearly, something can be done about this. I ask for help Edited by Varvarkin - 28 Jun 21 at 8:34PM