Re: Exporting an embedded image to a file

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Graham, the writeblob function there looks like it'll do the job!

Thanks very much,

John.

"Graham R Seach" wrote:

> John,
>
> The following KB article may be just what you want:
> http://support.microsoft.com/?kbid=103257
>
> Regards,
> Graham R Seach
> Microsoft Access MVP
> Sydney, Australia
> ---------------------------
>
> "John Crighton" <JohnCrighton@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:10E73E3E-2BE9-41E2-8448-B2901F2E4783@xxxxxxxxxxxxxxxx
> > Hi,
> >
> > I have a client that's using embedded images in their database, in one
> > field
> > in one table. The table has about 3000 records.
> >
> > The DB backend size currently resides at 1.5GB. Removing this field and
> > performing a compact/repair reduces the backend to 2.7MB.
> >
> > I could go through all 3000 records and save them manually, however it
> > would
> > be much easier if I could do this using VBA. Most of the procedure I can
> > do
> > myself, I'm just a little stuck on how to export an embedded image to a
> > file
> > using VBA, and I'd be very grateful for any help.
> >
> > Thanks in anticipation.
> >
> > John Crighton
>
>
>
.

Relevant Pages

  • Re: FIRST LETTER CAPITAL
    ... "Graham R Seach" wrote: ... You can call it from either VBA or SQL. ... > Microsoft Access 2003 VBA Programmer's Reference ...
    (microsoft.public.access.formscoding)
  • Re: Can you Export a multi table paramater query to a word templat
    ... John Thank you for your post, I'll have a look at the information you have ... I'm new to VBA (and programming) so its just a matter of putting ... Graham. ...
    (microsoft.public.access.externaldata)
  • Re: Actually...
    ... "Graham R Seach" wrote: ... MsgBox "Duplicate Entry" ... Microsoft Access MVP ...
    (microsoft.public.access.formscoding)
  • Re: Password change by user
    ... Set wrk = DBEngine ... Set usr = wrk.Users ... "Graham R Seach" wrote: ...
    (microsoft.public.access.security)
  • Re: Password change by user
    ... "Graham R Seach" wrote: ... Set wrk = DBEngine ... Set usr = wrk.Users ...
    (microsoft.public.access.security)