473,386 Members | 1,795 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Pictures in Access and stored in some folder

I'm building a form. Now I want my users to be able to add a picture. Because pictures slow down the database I want to store the pictures in some folder outside Access.

I have been searching a lot, and found many codes but none of them is working. Does anybody know how this works, or has a code for this application?

Many Thanx!
Nov 22 '07 #1
1 1423
ADezii
8,834 Expert 8TB
I'm building a form. Now I want my users to be able to add a picture. Because pictures slow down the database I want to store the pictures in some folder outside Access.

I have been searching a lot, and found many codes but none of them is working. Does anybody know how this works, or has a code for this application?

Many Thanx!
What you can do is Open a File Dialog Box and allow the User to select a Graphic File, store that File in a Sub-Folder under the Directory where your Database resides, store the Path to that File in the Database, then dynamically Load that File into an Image Control on a Form. If this is what you are looking for, what type Files do you want to allow? (*.jpg. *.bmp, etc.)? If this is not what you are requesting, then please explain.
Nov 22 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: NotGiven | last post by:
I am researching the best place to put pictures. I have heard form both sides and I'd like to know why one is better than the other. Many thanks!
4
by: Greg Lindstrom | last post by:
Greetings- I am running Python 2.3.3 on HP-UX and would like to access an Oracle 9i database. Looking through the vaults, I see 4 or 5 modules that might work and was wondering if anyone is...
2
by: Charles Robinson III | last post by:
How do I make Access display pictures within a form view as linked objects, so that the pictures which I am linking to are displayed within the database? I have a seperate folder for pictures to be...
4
by: Dale Ring | last post by:
Access 2000 I am trying to print a report that only some of the records have pictures. When the report prints, I do not want a blank image control showing on the report. This project is a test...
1
by: Veetold | last post by:
Hi. I have jpg files stored in a folder (\\server_name\folder_name) I have a report with a char field which part: left(, 6) and phase "i.jpg" is a file name I would like to display on my report...
3
by: Steven | last post by:
i want to be able to find jpeg's in a certain directory on my server and then link them to an id and display them in a form. at present the table is very basic but i am struggling on how to make...
12
by: Wadim Grasza | last post by:
I want to store and display (on a form or a report) multiple pictures per record in an access database. The pictures are not stored within the database. They are stored as files and the database...
8
by: cbmeeks | last post by:
I am writing my own family photo sharing site that I hope to take public (like so many others). Anyway, currently, when the user uploads a picture, I store the picture outside my htdocs folder and...
5
by: Alexnb | last post by:
Hello I am sure most of you are familiar with py2exe. I am having a bit of a problem. See the program has a few pictures involved and the .ico it uses for the windows. However, the pictures are...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.