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.

Thanks!

Is storing a hyperlink to the file an option (instead of saving the file within the database)?


AvgJoe

It would be if I could access it from anywhere (like a hotel room while traveling) but I would think the only way to do that would be with a VPN or something and I don't want to have to do that.

Right now I have the backend on our webserver, and can connect to it wherever I may be as long as I can get an internet connection.