update data from one Table to another Table having same field on both

[rameshmeena]

Dear sir,



I have one data base named employee.Accdb , which is loaded on two different locations

User at location 1 will update employee information, i use a query to extract the data for the updated information from this table.

i need to update this table in location 2, ( update the extracted datas from location 1 to location 2, )

I have one field called EmpNo. in table mentioned in Field properties Indexed = Yes ( No Duplicates) to prevent entering duplicate numbers


Please tell me solution to solve this

Ramesh

[Homegrownandy]

This is the opposite to what you should be doing. You need to have a backend database which only contains data. your front end databases then link to this data for input/visability/manipulation.

look on google on how to split your database. its not too complex.

[rameshmeena]

Thank you very much for your information, i dont want to split my data base

i need to update Table ( tblempdata) from this data base to another database having same Table name ( tblempdata) and same fields

[Homegrownandy]

why don't you want to split the database?

[rameshmeena]

thank you very much
these two locations are not in the same net work. the location are at different places ( main office and branch office), so instead of sending the back up of full database just send the table having modified data from branch office and update the table at main office.

that is what i am planning

[Homegrownandy]

Is there any possibility of making the connection online? even if its just the one table. I'm not trying to say 'you're wrong'. but if there are better options its worth exploring them.

maybe the way you're trying to do it is the only option, I can just see it causing you headaches.

[rameshmeena]

No there is no online connection between , and only way is to upload this on google drive, is that option workable ?

i tried the update option in Query, but some errors are appearing.
I cant export the table, as some of the datas in the original file will get lost.

[Homegrownandy]

you need to be connected to the internet to use google drive no? with office 365 now you get sharepoint which can host tables like access. I would recommend that.

[rameshmeena]

yes that is good solution, is one drive better or share point