Dear Mr. Cheryl,

I have gone through many solutions from you regarding MS Access questions. I would like a solution of 1 problem.

with refering the sample Database (Northwind) I would like to know in Employees Form (the photo of employee), If I am using the same form in my application on Network , If I add picture of employee on my Computer the location will be: C:\My Pictures\Photo1.jpb etc. Now If another user opens the form on his Machine he can not find the picture because the Imagepath text is C:\My Pictures\photo1.job but there is no picture named this on his Computer but on mine.



Please - reply at your earlies convenience & suggest a soluton.



Thanks in Advance.



My email is:

qaisarali2000@hotmail.com

Put your pictures in a shared network folder, and use the UNC path to that

folder to refer to them.



--

Regards,



Adrian Jansen

J & K MicroSystems

Microcomputer solutions for industrial control

"Qais" <Qais.13ys79@mail.mcse.ms> wrote in message

news:Qais.13ys79@mail.mcse.ms...

>

> Dear Mr. Cheryl,

> I have gone through many solutions from you regarding MS Access

> questions. I would like a solution of 1 problem.

> with refering the sample Database (Northwind) I would like to know in

> Employees Form (the photo of employee), If I am using the same form in

> my application on Network , If I add picture of employee on my Computer

> the location will be: C:\My Pictures\Photo1.jpb etc. Now If another

> user opens the form on his Machine he can not find the picture because

> the Imagepath text is C:\My Pictures\photo1.job but there is no picture

> named this on his Computer but on mine.

>

> Please - reply at your earlies convenience & suggest a soluton.

>

> Thanks in Advance.

>

> My email is:

> qaisarali2000@hotmail.com

>

>

>

> --

> Qais

> ------------------------------------------------------------------------

> Posted via http://www.mcse.ms

> ------------------------------------------------------------------------

> View this thread: http://www.mcse.ms/message520743.html

>

We have a significant number of photos in our network CLIENTS directory,

but each CLIENT has their own subdirectory, usually named LastName space

FirstName. The actual photos have a similar naming convention.



Would I variably reference using UNC like this?

\\Clients\[LastName]+" "+[FirstName]\[LastName]+" "+[FirstName].jpg



(Haven't created the DB yet to test - still nailing a few table design

issues)



>Put your pictures in a shared network folder, and use the UNC path to that

>folder to refer to them.





Gemstone Talent

www.GemTal.com

That looks right, but you would have to test.  Personally I would avoid

spaces in file and directory names like the plague.  I know MS allows them,

but many applications ( including MS ones ) fall over when asked to resolve

a path with embedded spaces.  Use underscores instead.



On a more databasic level, you have considerable redundancy in using your

client names both in the folders and in the filenames.  Maybe its more

convenient for identification, but it sure adds more complexity.



--

Regards,



Adrian Jansen

J & K MicroSystems

Microcomputer solutions for industrial control

<GemstoneTalent@c-my-sig.com> wrote in message

news:isvl609pu0dhr5krvblrcea1bn68j18lh5@4ax.com...  [color=blue]

> We have a significant number of photos in our network CLIENTS directory,

> but each CLIENT has their own subdirectory, usually named LastName space

> FirstName. The actual photos have a similar naming convention.

>

> Would I variably reference using UNC like this?

>  \\Clients\[LastName]+" "+[FirstName]\[LastName]+" "+[FirstName].jpg

>

> (Haven't created the DB yet to test - still nailing a few table design

> issues)

> 

that 

>

>

> Gemstone Talent

> www.GemTal.com