Results 1 to 8 of 8
  1. #1
    Star Lounger
    Join Date
    Jul 2002
    Location
    Petersburg, Virginia
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Large file, 'invalide function' (2002 SP-2)

    I have a huge file (just over 2 gigabytes)--which may or may not be relevant--and I am getting an "invalid function" when attempting various routine actions including deleting records, running a maketable query, entering certain text in some fields, compacting/repairing database. Size of file is due to .jpg objects in OLE "picture" field (switching to links vs. actual jpg files also produces same error). Any thoughts?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Large file, 'invalide function' (2002 SP-2)

    The size of your database is certainly relevant. 2 GB is the theoretical maximum size of an Access database (type Access specifications into the Answer Wizard for an overview of operating limits and specifications).
    You should <big>NOT</big> store images in a database (except for perhaps a very limited number of small ones). Storing images causes serious database bloat, as you have found out. Instead, store the path + file name in a text field, and use code to display the images.

    I have attached a zipped Access 97 database (it converts to Access 2000/2002 formatwithout problems) that demonstrates this approach. Open the Inventory form, and click Insert Picture to display a picture in the image control. Then, look at the Inventory table and at the code behind the form to see how it is implemented.
    Attached Files Attached Files

  3. #3
    Star Lounger
    Join Date
    Jul 2002
    Location
    Petersburg, Virginia
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Large file, 'invalide function' (2002 SP-2)

    Thanks. Three questions:

    1. What can I do at this point to get the database smaller? It won't let me delete records or compact.

    2. I couldn't access your file--there may be a system block on it from virus-protection software. Is there another way to get it?

    3. Would another solution be to link to the jpg object rather than insert it within the table itself?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Large file, 'invalide function' (2002 SP-2)

    1. I don't know - I have never had such large databases. You might try if the JetComp utility is able to compact the database. You can download it from <!mskb=295334>Microsoft Knowledge Base Article 295334<!/mskb>. You can also try to import database objects or data from the problem database into a new database. Take care not to come near the 2 GB limit again.

    2. If you PM me your e-mail address, I can send the zip file by e-mail, but if your system doesn't allow you to download the file from here, it may also block it in an e-mail...

    3. Storing a link should reduce the size, but I don't know if the database will allow you to change it - each change may temporarily increase the size of the database, and you have reached the limit.

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Large file, 'invalide function' (2002 SP-2)

    If you are in 2002 file format rather than the default 2000, you may also be running into a known problem with that format where even compacting a file does not get rid of all its growth. Unless all the size is in a single table, you could try import objects in groups rather than all at once into a new database. That will cut out a LOT of size, but if you have a 2Gb *table*, you have also reached the size limit on a table and you may have problems importing that table into another file. Good luck. We'll keep our fingers crossed <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16> for you.
    Charlotte

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Large file, 'invalide function' (2002 SP-2)

    I have sent it (a zip file containing the Access 97 database). You may want to edit your post to remove the e-mail address if you don't want it to be known to all.

  7. #7
    Star Lounger
    Join Date
    Jul 2002
    Location
    Petersburg, Virginia
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Large file, 'invalide function' (2002 SP-2)

    Tks, again. My email is xxx. I can get a database attachment released if know it's coming.

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Large file, 'invalide function' (2002 SP-2)

    Hah! Now this thread will be out of bounds for some Loungers because their content filter bans three consecutive x-es <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •