Sample databases

Here is sample databases chamber. Everyone is welcome to submit samples that meet this guidelines:

  • Sample uses AccessImagine control
  • Sample is not similar to one already posted here
  • Sample is functional, includes all files required and contains instructions (if needed)
  • Sample illustrates some real task (no “Table1”, “Field1” and so on)
  • Sample tables contain some sample data (at least few records) with real or semi-real data (no “Name: aaaaa” and donkey in customer profile)
  • Sample Access version should be as low as possible – if it works for Access XP/2000/2003, make an MDB.

Contacts database

Contacts database

Contacts database.mdb (472 Kb)
Author: MaxD
MS Access version: 2000 and higher

Techniques demonstrated:
– thumbnails generation
– continuous forms with pictures
– on-demand AccessImagine installation
– instructing user how to turn active content on

14 Comments

  1. sample access verion should be as low as possible? Is thise because keeping up with technology is a bad thing? – sheesh

    Reply
    • The aim is to make sample database accesible for as much people as possible.

      It’s not hard to press “Save as…” and select “Access 2003”. Sure, if you use some newer version specific functions, you shouldn’t do this.

      Reply
  2. would this work with a mysql back end? if so what field would it be?

    Reply
    • Yep, AccessImagine works perfectly with SQL backends. You can use any BLOB-style (binary data) field type.

      Reply
  3. hello,
    after i downloaded the file and run in access 2003 i got this error “RegKey = myWS.RegRead(“HKEY_CLASSES_ROOT\AccessImagine.Picture\”)” can’t find the library.

    any solution for this? thanks.

    Reply
    • It seems that this error is produced by AccessImagine autoinstall script, included into demo database.
      Does it shows up when you insert AccessImagine object into clean database?

      Reply
  4. Hi Max, just what i was looking for. created a decent database for on the job fault listing with pics from your active x dll. liked it so much i bought it. Would like to know how i can share this database.

    Reply
  5. Hello.
    Does the thumbnails generation works in demo version?
    Thanks.

    Reply
    • Yep, trial version is fully functional (but shows some reminders).

      Reply
  6. I’m not very strong with Access and I can’t get the export feature to work.

    For AccessImagine images you should use SaveFile VBA command. Place a button on form with AccessImagine image and bind such a script to it:
    For i = 1 To N
    Pic.SaveFile (“c:\MyPics\” + Str(ID) + “.jpg”)
    DoCmd.GoToRecord , , acNext
    Next i

    I get a compile error/ Syntax Error

    Reply
    • You should replace N with your actual number of records.

      Reply
  7. I am using access 2007 and have a table with URL’s in it to jpg images, I am trying to display the images in a report, I have bound the control to the pic column but nothing is displaying when i run the report

    Reply
    • Maybe that images are HTTPS? AccessImagine is unable to show HTTPS images.

      Reply
  8. Incredibly awesome, do you guys realize you are life savers.
    I was working on an access archiving database where the image control can not display linked images, thanks to your ActiveX Control, I am now able to do it.

    Reply

Submit a Comment

Your email address will not be published.