Does anyone know how this can be done? The only solution I have found so far in my search is the PHP Extension for ODBTP: http://odbtp.sourceforge.net, and I don't think I can use that. Here is what I need to do: From a web based program connect to an Access DB on an office computer. The web based program is on a shared server so I will be limited on how I can change the server. The office computer is behind a router. I know that it would be easy to move the Access DB to the web server and connect that way. The problem is that I can't do that because the Access database is connected to another local program which most certainly can't be moved to the web server. Anyone do anyhting like this before? Any ideas?
You won't be able to achieve it.... you need the office computer to be able to be accessed from the internet... so if you typed in the IP address of the office computer you can access it from anywhere.... this of course is not a very good idea since it's a huge security risk... your choices: 1) stop using access and use mysql 2) move the access to a web server that runs access db That's pretty much it.
Thats what I concluded as well. I was hoping someone here had a crafty way to do it. I really can't move the database to the web server. Here is my plan B: Write a program for the office computer that runs in the background. This program checks for updates to the AccessDB at the office and updates the daabase on the web server. Is that feasible? It's either that or set up th office computer to be accessed from th internet..