help required urgently about (php , Mysql , Access, VB)

[oovijayg]

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 !

[Shazbot!]

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.