Posts: 251 From: Port Orange, FL Volusia Status: offline
update local db with info from db on webserver - 5/3/2006 9:11:39
Hi all,
I've just developed an app that creates powerpoing slides from an Access db. I published the db from our webserver to my local drive and created the app inside Access (VBA). I'd like to be able to update that local db with new information entered in the db on webserver without having to publish the db and then copy the tables (which is how I've been doing it). I don't want to overwrite the db, because I'm afraid I'll lose all of the coding I've done. Is there a way I can connect the two db's (ODBC or something) to update the information? I hope I have explained it well. Thanks, Carrie