"invalid argument" =>2GB - true or false?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Robert Wakefield
    New Member
    • Jul 2007
    • 3

    "invalid argument" =>2GB - true or false?

    Hey, all. I'm charged with the creation of visual product recognition software. I chose Access, because it's available. I'm importing graphics into a form, and it's been working, but the 2gig limit is reached after about 135 jpeg imports. I need to import about 1000, in total. Is this a problem I can work through with access, or do I need to rethink it? I've compacted/ repaired as much as I can...Thanks for you input.
  • missinglinq
    Recognized Expert Specialist
    • Nov 2006
    • 3533

    #2
    I think most people here will agree that using Access for an application that deals primarily with graphical images is a very bad idea! Access does many things well, but manipulating images is not one of them!

    You speak of "importing" images. If by this you mean that you're actually importing the images and then storing them in a table, you need to stop doing this. Instead, you need to store the path to the images in a table.

    Graphics really aren't my long suit, and maybe others here will be able to give you more help!

    Good Luck!

    Linq

    Comment

    • puppydogbuddy
      Recognized Expert Top Contributor
      • May 2007
      • 1923

      #3
      Originally posted by missinglinq
      I think most people here will agree that using Access for an application that deals primarily with graphical images is a very bad idea! Access does many things well, but manipulating images is not one of them!

      You speak of "importing" images. If by this you mean that you're actually importing the images and then storing them in a table, you need to stop doing this. Instead, you need to store the path to the images in a table.

      Graphics really aren't my long suit, and maybe others here will be able to give you more help!

      Good Luck!

      Linq
      The article in the link below discusses the alternative methods for use in ms access, and the pros and cons of each.


      This link is for an image control add-in for ms access that extends Access's capabilities for handling graphic images.

      Comment

      • Robert Wakefield
        New Member
        • Jul 2007
        • 3

        #4
        Cool...

        I should have mentioned my novice...sorry.

        That link offers a solution to exactly what I was struggling with. It seems that because there's a market for DBPix, I guess I'm not the only person who's tried (and failed) at grapic-based DBs. :-)

        I'll explore the new software, and let you know how it goes...

        I really appreciate your expertise...you guys rock!

        RW

        Comment

        Working...