DAO 12.0 Big Images in Access
-
I'm preparing an WPF article that creates storages automatically from classes with nesting and else. The issue is that in the ACCESS db execute , everything works fine but images bigger than 12 KB I get the error: 'System resource exceeded.' I show the process:
public Database db;
public DBEngine engine;
this.db = this.engine.OpenDatabase(file, Missing.Value, Missing.Value, Missing.Value);
access.db.Execute(String.Concat(query, values), Missing.Value);in values, the data is directly:
0x89504E47...454E44AE426082
It works with small images, and if I add with the Access directly design it works, so the field type is right, Maybe is an issue with connection size properties. Does any store a big image with DAO12,ADO, or OLEDB with an Insert statement? Thanks in advance, a great article is coming...
Juan Pablo G.C. Overrider Blog
-
I'm preparing an WPF article that creates storages automatically from classes with nesting and else. The issue is that in the ACCESS db execute , everything works fine but images bigger than 12 KB I get the error: 'System resource exceeded.' I show the process:
public Database db;
public DBEngine engine;
this.db = this.engine.OpenDatabase(file, Missing.Value, Missing.Value, Missing.Value);
access.db.Execute(String.Concat(query, values), Missing.Value);in values, the data is directly:
0x89504E47...454E44AE426082
It works with small images, and if I add with the Access directly design it works, so the field type is right, Maybe is an issue with connection size properties. Does any store a big image with DAO12,ADO, or OLEDB with an Insert statement? Thanks in advance, a great article is coming...
Juan Pablo G.C. Overrider Blog
Whenever I have needed to use images with an Access database, I have always stored the images in the file system and then just a pointer to the image in the database (an url, path or whatever is appropriate for the app). Access does not play well with images when trying to store them in the database.
-
Whenever I have needed to use images with an Access database, I have always stored the images in the file system and then just a pointer to the image in the database (an url, path or whatever is appropriate for the app). Access does not play well with images when trying to store them in the database.
Of course, you can always do that, but is a test, in access I can do, and I would like to know how to do in code.
Juan Pablo G.C. Overrider Blog