From: Joel Burton <jburton@scw.org>
To: Greg Speegle <Greg@10happythings.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Some advice re:bound/unbound forms for MS Access
Date: Thu, 30 Nov 2000 17:21:49 -0500
Message-ID: <3A268CAD.29805.DE88A0@localhost> (raw)
In-Reply-To: <3A26CAF8.D826C341@10happythings.com>
> Can you store binary data in Access tables? Specifically, if I want to
> store an image and not keep it anywhere but in Access, how do I do
> that?
Either:
a) as a large object. So all the lo help in the manual. It's a little
scattered around, and I'm not clear about all the ins and outs, but it
does let you stick large, arbitrary binary stuff in your tables.
However, in Access, it doesn't appear as a graphic file or movie, as
it would if it were an "OLE Object". Perhaps it can; I've never
figured out how.
b) as a bytea type. Bytea is a little-known, perhaps little-used field
type for binary data. With pg7.0.x, you'll still be limited to 8k rows,
but with the magic of 7.1, that restriction is gone. Again, although
you can store binary data this way, I don't think it can *appear*
this way, as an "OLE Object". Perhaps wiser minds know how.
Good luck.
--
Joel Burton, Director of Information Systems -*- jburton@scw.org
Support Center of Washington (www.scw.org)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jburton@scw.org, Greg@10happythings.com
Subject: Re: Some advice re:bound/unbound forms for MS Access
In-Reply-To: <3A268CAD.29805.DE88A0@localhost>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox