synchronization database
-
I have two database one on server(oracle) and one on client(MSaccess) . I want to synchronise database beetween server and client. So I don't allow anyone to update, insert or delete on server database. How to clock a table that i want synchronise with client on server database. Help me
-
I have two database one on server(oracle) and one on client(MSaccess) . I want to synchronise database beetween server and client. So I don't allow anyone to update, insert or delete on server database. How to clock a table that i want synchronise with client on server database. Help me
Well I also had to do such a project, but the other way around, I had to put data from the client (MS Access) into the SQL server. I coded everything in vba in MSAccess. In my situation that code connects to the server, loops through all rows in my source table, and does an insert on the sql server. If you need VBA code examples please let me know.