ms-access-2013

Working with Unicode file names in VBA (using Dir, FileSystemObject, etc.)

by

It sounds like you are being misled by the fact that while VBA itself supports Unicode characters, the VBA development environment does not. The VBA editor still uses the old “code page” character encodings based on the locale setting in Windows. Certainly FileSystemObject et. al. do in fact support Unicode characters in file names, as … Read more

Storing an image into an Attachment field in an Access database

by

As you have discovered, you cannot use a SQL statement to insert files into an Attachment field in an Access database. You have to use the LoadFromFile() method of an ACE DAO Field2 object. The following C# code works for me. It is adapted from the Office Blog entry here. using System; using System.Collections.Generic; using … Read more