I have microsoft access connected to a my SQL server via ODBC drivers, unfortunatly image put into a blob field through access are incoded as an OLE object, and useless to PHP. The way I chose to get arround this was to make link in an access form that points to a php page where the user can upload the images they want. The only problem is when a user makes it to the PHP page from access they have to manualy insert the primary key of the record they want to upload images to. I can't figure out how to put a variable in the access form URL. eg "http://localhost/imageupload.php?key=[access_feild_name]"
if that isnt posible, then is it posible make a macro to find the value of current feild and exec the web browser with the argument. eg exec("netscape.com http://localhost/imageupload.php?key=ms_access_var);
