" can we move them(photos) to separate folder and call them display to my access database? "

Yes, you can store only the filename in the database. Example code for retrieving is here.

see: http://support.microsoft.com/kb/285820

" Do we have the other way to decrease the photo size/quality in my access database "

This also might help. High resolution pictures can be very large. I use a batch program in Photoshop to resize images. There are web tools available to do this. Generally, I like to stay away from storing images in access db's.

I'm creating my own data access for my contact list, I created some basic files such as ID, name, number, contact and photo. The main problem is photo path object. When I upload the photo for a while ( around 150 ++ lists). It seems that my file look more heavy and keep loading or not responding when we entry new records.

Question1: can we move them(photos) to seperate folder and call them display to my access database?

Question 2: if yes. Please suggest me the code or any trick to link it from outsource to access file

Question3: if no. Do we have the other way to decrease the photo size/quality in my access database

Thanks

Mia