Occumouctduex
New Member
Here's my situation:two computer in two separate city use one MS-ACCESS .accdb file which computer#1 is for data entry, and Computer #2 is for using data and reports and ... .
i need to find the best way to sync the .accdb file between these two computers without losing any data and of course without any duplication. please note that there are more than 20 tables in this .accdb and all have a field named "ID" with "AutoNumber" Type.What do you suggest? Export data from computer#1 in xml format and import to computer#2 or any other ways?I'm looking forward for your helpful answers.Thank you for taking time.
i need to find the best way to sync the .accdb file between these two computers without losing any data and of course without any duplication. please note that there are more than 20 tables in this .accdb and all have a field named "ID" with "AutoNumber" Type.What do you suggest? Export data from computer#1 in xml format and import to computer#2 or any other ways?I'm looking forward for your helpful answers.Thank you for taking time.