oovijayg Posted June 21, 2007 Share Posted June 21, 2007 I am working on a project in which the development has 2 phases: first is web site development ( using php , Mysql, Xampp server) second is an application in VB having database in MS Access. I want to transact data automatically between these two databases i.e. Mysql and Ms Access. I mean to say that any change occuring in Ms-access reflects same in Mysql database and vice-versa. I am not able to figureout the way to do. PLZ Help me ! Quote Link to comment Share on other sites More sharing options...
Shazbot! Posted June 26, 2007 Share Posted June 26, 2007 I am not familiar with MySQL but you should be able to create an OBDC DSN (control panels, administrative tools, Data Sources) to the MySQL server and connect to the Access database and use Access as the front end. Create the DB in MySQL and use that as the primary and Access as the front-end. 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.