Hi everyone,
I am making a website for a client. They get an Access database full of their used products from their corporate headquarters on a weekly basis. My client has told me that he knows a web developer that has created a system (who has done all the other branches websites for this company) in which all my client has to do is upload the 80mb Access database to their web server and it will automatically load the new data into their website.
I figured this is possible, and seems fairly easy, but i was wondering how the PHP makes a connection to the Access database? I cant remote onto the webserver via VPN or anything like that to create an ODBC connection, so how would this work? Is this possible on most any webserver?
What i am having to do right now is create a VB program to extract the data into a text file, and extract the pictures to a folder......then upload them to the server (the text file uploads the data into a MySQL database). This way works, but there are a few problems....
One is that the pictures do not always come out in JPG format....some come out in a .tiff file which is unreadable for some reason. Second is that doing it this way requires a lot more steps that i would like my client to have to do. To upload the Access database in one large file...no other steps required...is much more simple for me to explain.
So is there an easy way for me to do this? I absolutely have to be able to show pictures of the products on the website (which are embedded within the Access DB.)
Thanks for any help,
Ryan
