Re: 2GB size limitation workaround

From: Roger Carlson (NO-Rog3erc-SPAM_at_hotmail.com)
Date: 06/24/04 

Date: Thu, 24 Jun 2004 08:07:38 -0400

Unfortunately, I don't know how to save a picture that has been stored in
the database back to a file. Perhaps there is some ActiveX image control
that allows you to SaveAs, but I don't know of any. Still, it's a place to
start looking.

Sorry I can't be more help. 

-- 
--Roger Carlson
  www.rogersaccesslibrary.com
  Reply to: Roger dot Carlson at Spectrum-Health dot Org
"Karen" <karen.roem@ntlworld.com> wrote in message
news:2095e01c45963$1496ad70$a101280a@phx.gbl...
> Dear Roger and John, many thanks for your feedback. I am
> aware - with hindside - that storing the pictures in
> Access was a bad idea but a lot of work has been put into
> entering (200) records that way. Do any of you know of a
> way to convert the embedded pictures to a linked one or do
> we have to do that manually? (setting the picture type to
> link applies to new records only, not for existing ones :-(
>
> Once again thanks for your help!
>
> Karen
> >-----Original Message-----
> >There is no workaround for the 2GB database size other
> than splitting the
> >database into multiple databases less than 2GB.
> >
> >However, it is *very* *bad* *practice* to store the
> pictures IN Access.
> >Sure, it's possible, but Access is not really designed
> for it, as you have
> >discovered.
> >
> >One solution is to leave the pictures in a directory on
> the hard drive and
> >only store the path and file name.  You can then load the
> picture
> >programmatically on a form or report.  On my websites
> (see sig below) is a
> >small sample database called "Picture.mdb" which
> illustrates how.
> >
> >If you need to load them in an external program, you can
> store the path as a
> >hyperlink.  Clicking the hyperlink will open the file in
> the associated
> >external program.  Another sample: "SetHyperlink.mdb"
> illustrates how to do
> >that.
> >
> >You can also move files around your harddrive or network
> using Access with
> >the Name(), FileCopy(), Dir(), and Kill() functions,
> which all work in the
> >Operating System on files.
> >
> >Your only other option is to move up to a more powerful
> database engine like
> >Oracle or SQL Server.
> >
> >-- 
> >--Roger Carlson
> >  www.rogersaccesslibrary.com
> >  Reply to: Roger dot Carlson at Spectrum-Health dot Org
> >
> >
> >"Karen" <karen.roem@ntlworld.com> wrote in message
> >news:2011901c45932$20756d60$a601280a@phx.gbl...
> >> I'm approaching the 2GB size limitation. Compacting the
> >> database has no effect and the other workaround to split
> >> the database is not an option (for us).
> >>
> >> Does anybody has any other recommendations?
> >>
> >> PS
> >> Some background information: this is an Access 2000
> >> database with pictures and it was decided to embed the
> >> pictures in order to activate them using PhotoEditor and
> >> so that files can be moved to other locations on the
> disk.
> >>
> >>
> >>
> >
> >
> >.
> >

Relevant Pages

  • Re: Access newbie picture question
    ... While the DBPix control is an excellent reccomendation your statement ... LoadSaveJpeg.zip contains a database demonstrating how to use the Intel ... >>> I have to store some pictures in the database. ... is there a way to display the FileOpen ...
    (microsoft.public.access.forms)
  • Re: Convert jpg to bmp
    ... when asked to confirm (this will remove the jpg from the database). ... way to go with inserting pictures, ... an EMF file in the OLE cell but only to have the filename show, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Image Management in FM database
    ... You can do all of this, but you need applescript or a plug-in like troy ... then naming the pictures according to the id of the roecord. ... I have a situation where I have a database managing house inspection ... I would like to customize the report that I print out for the ...
    (comp.databases.filemaker)
  • Re: MS Access 2003 does not work properly with JPGs, Office XP did
    ... > pictures is about as useful as a non-relational database. ... >> FMS Professional Solutions Group ... >> Software Tools for .NET, SQL Server, Visual Basic & Access ...
    (microsoft.public.access.setupconfig)
  • Re: MS Access 2003 does not work properly with JPGs, Office XP did
    ... pictures is about as useful as a non-relational database. ... >> This post is a suggestion for Microsoft, ... To vote for this suggestion, ...
    (microsoft.public.access.setupconfig)