RE: linking/embedding images

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

well first let me warn you that embedding lots of images i.e. per record -
is dangerous because it bogs down your db with so much size.

but with that warning aside

in my A2003; in table design view - you define the field using the pull down
as an OLE object

then in the table in table view where you actually add data; in that field,
right click and then select 'insert object', and then you are presented with
a button choice of 'Create New' or 'Create from File'. Select Create from
File and then one just browses to wherever the image file is found and
selects.

that's how it works for mine. One additional thought - your error message
possible might occur if you have copied in a pre-existing DB that had already
a defined link to an image source which is no longer working......in any case
a sanity check with a virgin new db and new table may be helpful
--
NTC


"Tom Gettys" wrote:

> I am using Office 2003. Included is an example database named Northwind.mdb
> that has an image associated with each record. I am try to mimic that
> function.
>
> In my database I have a field of type OLE Object. When I try to use "Insert
> Object" to associate an image with this field I get an error message that
> says "The connection with the OLE server was lost, or the OLE server
> encountered an error while you were using it.".
>
> In trying to figure out what was going on I found a site that claims that
> Office 2003 does not provide an OLE server. Does this mean that the
> Northwind example is using some other technique to have an image in a record?
>
> I am hoping someone with be able to point me to an example with step-by-step
> instructions on how to achieve this.
>
> Thank you very much for reading all this!
.

Relevant Pages

  • Re: Empty Bound Object Frames
    ... An ole object requires an OLE server to display it. ... Install that app and you should be ...
    (comp.databases.ms-access)
  • F A O John Vinson
    ... I am using access 2003 and have successfully linked word documents to my ... A problem occurred while accessing the OLE object. ... * The OLE server may not be available because it's on a network server and ... Try re-establishing the connection. ...
    (microsoft.public.access.gettingstarted)
  • Problem viewing linked images on form
    ... the following error "A problem occurred while accessing the OLE object. ... OLE Server may not be available because it's on a network server and you lost ... This form opens up for different records and I would like the ability ... An example would be an employee ...
    (microsoft.public.access.forms)
  • RE: linking/embedding images
    ... in table design view - you define the field using the pull down ... One additional thought - your error message ... >> In my database I have a field of type OLE Object. ... >> says "The connection with the OLE server was lost, ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Custom Startup Wizard error: OLE server isnt registered
    ... being able to debug the code, I found that the underlying error message was ... > When using the custom startup wizard in the Access 2003 Developer Extensions, ... > Find potential missing VBA references ... The OLE server isn't registered. ...
    (microsoft.public.access.devtoolkits)