467,219 Members | 1,461 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,219 developers. It's quick & easy.

Storing and extracting binary files in Access

Hello,

I am wondering about including binary files in my MS Access database
application. I want to keep my application as just a single MDE or MDB
file, but the users of the app may need some additional files. One file
is an ODBC driver for connecting to an external database, this is a 120
kb DLL. The other is a 20 kb PDF help document for using the database
application. I am wondering if it is possible to store these files
within the database and programattically write them to some directory
on disk when the user clicks a button on a form.

Thanks for any advice,
Dave

Feb 17 '06 #1
  • viewed: 7083
Share:
1 Reply
"Dave" <da********@mail.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...
Hello,

I am wondering about including binary files in my MS Access database
application. I want to keep my application as just a single MDE or MDB
file, but the users of the app may need some additional files. One file
is an ODBC driver for connecting to an external database, this is a 120
kb DLL. The other is a 20 kb PDF help document for using the database
application. I am wondering if it is possible to store these files
within the database and programattically write them to some directory
on disk when the user clicks a button on a form.

Thanks for any advice,
Dave

You could store such a file as a binary large object bitmap (BLOB) where the
whole data for the file is stored in the field of a table. See
http://support.microsoft.com/?kbid=210486 for more.
In fact, you could even store the file data in a code module, where the data
is held as a series of ascii strings representing the binary data which is
then written out to a file. This approach is less standard and you would
need to write a routine which would read the file data and then effectively
write the vba for you. I've done it like this before, but perhaps the first
idea is easier to recommend.
Feb 17 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

27 posts views Thread by Eric | last post: by
3 posts views Thread by Ringo Langly | last post: by
6 posts views Thread by alice | last post: by
2 posts views Thread by Chris Murphy via DotNetMonster.com | last post: by
10 posts views Thread by Fabuloussites | last post: by
15 posts views Thread by JoeC | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.