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. Quote Link to comment 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? Quote Link to comment 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. Quote Link to comment 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. Quote Link to comment 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. Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.