Copy Data from Server to local machine
-
Hi all 1.I would like to copy(programmactically) some tables(Mysql DB) from server into local machine(MS Access) when a user login is successful. 2.After a user has done something on local database, (eg. update, insert etc), the changes will update back the sever database. Is there any idea pls? Could anybody help me? Thanks in advance. Kyi Kyi
-
Hi all 1.I would like to copy(programmactically) some tables(Mysql DB) from server into local machine(MS Access) when a user login is successful. 2.After a user has done something on local database, (eg. update, insert etc), the changes will update back the sever database. Is there any idea pls? Could anybody help me? Thanks in advance. Kyi Kyi
Are the client and server on the same network? If so you can connect directly to the server from your app and transfer the data. Otherwise you'll need a web service to access the server data
I know the language. I've read a book. - _Madmatt
-
Are the client and server on the same network? If so you can connect directly to the server from your app and transfer the data. Otherwise you'll need a web service to access the server data
I know the language. I've read a book. - _Madmatt
-
Hi all 1.I would like to copy(programmactically) some tables(Mysql DB) from server into local machine(MS Access) when a user login is successful. 2.After a user has done something on local database, (eg. update, insert etc), the changes will update back the sever database. Is there any idea pls? Could anybody help me? Thanks in advance. Kyi Kyi
1.Get the DataTable from the MYSQL SERVER. and then insert the data to the MS Access. 2.compare the difference of data between MYSQL SERVER and MS ACCESS and then update the changes back to MYSQL SERVER. This web site is useful for you about the connection string. :) http://connectionstrings.com/[^]
-
1.Get the DataTable from the MYSQL SERVER. and then insert the data to the MS Access. 2.compare the difference of data between MYSQL SERVER and MS ACCESS and then update the changes back to MYSQL SERVER. This web site is useful for you about the connection string. :) http://connectionstrings.com/[^]