Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2006
    Location
    Florida
    Posts
    2

    Access Limitations

    I have an Access 2000 DB. I have a record for each pet linked to a grooming record. In the pet record there is a bound object frame for a picture of each pet. Each picture is about 25kb. At about 1000 records the db reached the 2gig limit and kept giving me "Invalid Argument" error. Shouldn't I be able to expect more than 1000 records. If not is there another product I can use. Or use something as a backend to a VB app. Cant afford SQL.

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    Almost all Access developers I know advise against storing images in an Access db: it leads to file size bloat and makes the db more vulnerable to corruption.

    I always recommend that you store your images in a specified folder, and then store either the file name or the full name and path in the db. Then, on your forms or reports, use VBA code to update image frames to show the image from the specified file.

  3. #3
    Join Date
    Aug 2006
    Location
    Florida
    Posts
    2
    Thanks. I am not sure I have the expertise for that but I will try.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Date Selectable limitations
    By Robert_Clash in forum Access
    Replies: 0
    Last Post: 11-27-2007, 09:00 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums