minneyx Posted March 31, 2009 Share Posted March 31, 2009 Hello All, Just wondering if anyone can help me, I am making a database that is going to be run on a in house server (ms access) and I also want part of the database to be copied (with pictures) to a database for the website. What is the best solution for this? Thanks in advance, Shane. Link to comment https://forums.phpfreaks.com/topic/151916-php-linked-to-accessmysql-database-and-in-house-server/ Share on other sites More sharing options...
revraz Posted March 31, 2009 Share Posted March 31, 2009 Have your code copy the parts that need to be where you want them? Link to comment https://forums.phpfreaks.com/topic/151916-php-linked-to-accessmysql-database-and-in-house-server/#findComment-797721 Share on other sites More sharing options...
minneyx Posted March 31, 2009 Author Share Posted March 31, 2009 Sounds like that is going to be the only way then. Was hoping there was a way to link the access db to mysql or sumat like that. Thanks anyways, Shane. Link to comment https://forums.phpfreaks.com/topic/151916-php-linked-to-accessmysql-database-and-in-house-server/#findComment-797784 Share on other sites More sharing options...
revraz Posted March 31, 2009 Share Posted March 31, 2009 Ah I see what you mean, and I don't really know. Try searching for something like that and see what pops up. Link to comment https://forums.phpfreaks.com/topic/151916-php-linked-to-accessmysql-database-and-in-house-server/#findComment-797826 Share on other sites More sharing options...
minneyx Posted March 31, 2009 Author Share Posted March 31, 2009 Couldn't find a way around hard coding the whole lot... Thanks anyways. Link to comment https://forums.phpfreaks.com/topic/151916-php-linked-to-accessmysql-database-and-in-house-server/#findComment-798168 Share on other sites More sharing options...
taquitosensei Posted March 31, 2009 Share Posted March 31, 2009 create tables with identical structure in mysql then you can link the mysql tables in access using ODBC http://dev.mysql.com/downloads/connector/odbc/5.1.html then run queries in access to insert the data into the linked mysql tables Link to comment https://forums.phpfreaks.com/topic/151916-php-linked-to-accessmysql-database-and-in-house-server/#findComment-798224 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.