I'm using a Access 2003 Front end with a MySql backend.
We create quotes using this database and I would like to store the pdf in a mysql table to keep track of old versions as they change multiple times before the final.
I'm search a lot online and seems like because I'm using a MySql back end it might be a little more involved to get this to work. I can't seem to get it working.
Using Leban's code, I have the creating the pdf part working ok. This pdf is always stored in the same location with the same file name on my hard drive. I then think I want to insert this as a blob into a table using some controls on the Print page to populate the customer info in the table.
I just can't seem to figure out how to automatically insert the pdf file as a blob into the table.
Does anyone have any experience with this or have some suggestions on how to proceed? We operate out of a couple locations and I really would prefer the pdf be in a table on our webserver so that it can be accessed from anywhere, as opposed to just storing a file location in the database.