Hi,
I'd really appreciate any input for this issue we've been having.
I work for an environmental non-profit. We have a database that is used to
store our wildlife tracking data, which includes photos of wildlife taken from
the motion-detector cameras set up near Vail, CO. The database was originally
created in the 2003 version Microsoft Access (not by me), and because of the
large number of records (4000+), the database is now at its 2 gb limit set by
Microsoft. The non-profit employees are set on storing the photos in the
database.
We decided to migrate the database to PostgreSQL, because of the ability to
still use Access as the front-end (there are forms, queries, etc that are
easier for the volunteers to use in Access than learning SQL.) We bought the
DBConvert program, which stores the photos in bytea format in PostgreSQL.
However, when we try to link to the PostgreSQL database using Access, the
pictures are no longer recognized as OLE - instead they are binary and are no
longer visible using Access' image viewer.
I realize this could be an issue on any of the three fronts: DbConvert, MS
Access, or PostgreSQL. I'm currently in contact with the DBConvert company, but
I'd like some feedback from the bright minds on this mailing list.
Has anyone encountered this sort of problem before? Short of taking the photos
out of the database and just saving a link to their folder(s), can anyone think
of another solution?
Thanks very much!
-Kristina
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
