Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rating: Thread Rating: 2 votes, 5.00 average. Display Modes
Old 05-30-2013, 07:48 PM   #1
claude.kelly
Newly Registered User
 
Join Date: May 2013
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
claude.kelly is on a distinguished road
Image upload to server and store image path mysql

Hi I have migrated a local database to mysql backend.
I am very proud of my efforts so for in that all relationships work etc, and all clients can connect through anodbc connection.
When the db was local I had images stored for students, but realised tht this is very ineffiecent and so removed them and stored the acutal image ina shared directory on the msql server then adjusted the records to have a text field containg the path to the image ie \\server_ip\share\path
Having adjusted my student record form now I can display student pictures as they flcik through although I had to populate empty photo field with a link to an empty avater type image file otherwise the image would not change when the record changed if there was no image.
My problem now is two fold.
1) I think i need to use a relational directory and am not certain about where it be in relation to? Is it the http / www directory or the mysql directory or in relation to where the access db file for front end is located (also on the same server?). I installed WAMP FYI on the server default settings
I need relational as will be accessing from internal and external network so therefore includeing the ip address will no longer work.and also does not work if accessing from the serveritself which will also act as a client.
2) I want to be able to select student photo on various local pcs's to then upload to the mysql server and also store the path in the image location text field. But I am at a complete loss where to begin with this.
OK I hope there is someone out there who can help steer me to the right solution.
Thanks for any part or full help you may offer.

claude.kelly is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Image upload for user Fides Forms 28 12-10-2012 06:27 AM
MYSQL and Image Storage Steve R. PHP & MySQL 4 09-22-2012 04:46 PM
Webcam image store j.hagon Forms 9 04-30-2011 02:27 PM
path of an Image khadem1386 Tables 5 08-25-2007 11:07 PM
Get Image Path BillyMac Forms 3 12-17-2006 08:25 AM




All times are GMT -8. The time now is 05:35 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World