Question Linking OLE Objects : Access 2003

[grinder332518]

My table consists of a few populated text fields and 2 blank OLE Object fields.

For the last 2 days I have been creating the OLE Objects as follows :

Initially I select Tables from the Objects list, and then from the Datasheet view
I click on the appropriate {blank} field, and then click on the following path :

Insert > Object > Create from file > Browse > ( Locate file from my PC) > Link > OK

I can then click on the newly populated field, and “see” the correct file OK.

My problem is that I now need to make the db available to colleagues,
but my linked files are located in my PC’s C drive.

So if my PC isn’t powered up, this will not work.

I can copy these linked files from my PC to a shared network drive,
but is there any way to trick the db not to look to my C: drive, but to the new shared address ?

Or will I have to re-enter all the links, as a punishment for my lack of foresight ?

Many thanks

 

[Boro]

Change in options default path for access. I didn't try but it should work

 

[Simon_MT]

The most flexible way to create a Path in your database use can set up the local path for your PC and a server path when you distribute your database or simply have one location of the images for everyone.

Simon

 

[grinder332518]

Hi Boro
When I select Options, I get lots of tabs, as follows :
Advanced International Error Checking Spelling Tables/Queries
View General Edit/Find Keyboard Datasheet Forms/Reports Pages
I have selected them all, but the only place I can set such a path is in 'General', where there is a 'Default database folder', preset to 'My Documents'. I changed this to the shared address but got "Windows cannot find 'MYDocu~\ etc"', so I suspect this is not the path you mean.
Can you further advise ?
Many thanks

 

[Boro]

Yes, i thought on this soloution you have tried, but as i mention i didn't try it myself. Did you move data base to shared folder? You sholud expriment with this, maby you miss something ....

 

[grinder332518]

I did move the sources to a shared drive. I now need to write an update query to amend the setting for the OLE object to point to the new destination.