Revision History
Site Map

Graph: dbPix image storage vs OLE Embedding and Linking in Microsoft Access

Importing pictures to Microsoft Access with DBPix

If you want to import pictures to Microsoft Access there are two main methods to choose between. You can import the pictures either by embedding them or linking them. The first method involves storing the pictures inside MS Access, whereas the second stores the pictures as external files.

If you choose to import pictures to Access with the embedding method, there are three different ways of doing this. You can use the Bound OLE frame, which is very simple but involves a lot of potential problems (e.g. high storage overhead, configuration problems etc.). You can also embed pictures using the Access Image Control, but if you've ever tried this you will know that it is very difficult to implement and highly susceptible to various configuration problems. The third way of importing pictures to Access with the embedding method is by using DBPix. With DBPix, adding pictures to Microsoft Access is quick and easy, there is no storage overhead and the configuration is simple and reliable. Another benefit of using DBPix is that it provides enhanced functionality such as built-in file browsing, preserved EXIF info, TWAIN scanner integration and more.

If you choose the linking method to import pictures to your Access database, you can also use the three methods described above. Again, the Bound OLE Frame is simple to use but highly susceptible to a variety of different configuration problems. If you use the Access Image Control to link pictures to your database, you will find that it is moderately simple to implement and won't cause any problems with storage overhead. Nevertheless, you are likely to experience a lot of configuration problems, and you'll have to use plenty of workarounds to avoid certain image control behaviours. With DBPix, all these problems can be avoided. If you use DBPix to import pictures to Access with the linking method, you will find that it is both reliable and simple to implement. As mentioned above, this software also provides enhanced functionality when you import pictures to Access.

Imaging for Access that's Easy, Efficient & Fast
  • NO OLE Bloat
  • NO App Dependencies
  • NO Complex Coding
  • NO Performance Penalty
  •  DBPix logo
    Read More