Not sure were to post this.....*lol*
I need to have a MAIN workbook query a DATA workbook (usually closed) and update with the new records added. That is User1 enters data in DATA.xls User2 opens MAIN.xls and can update his MAIN.xls with any new records added in DATA.xls.
Long story short, I’m not proficient enough to get good Access environment set up and using the same workbook causes all sorts of problems as Users will or might be using simultaneously.
I tried the import query but it always overwrites the existing data, I just want it to add new records only.....
Any suggestions or help ?
I need to have a MAIN workbook query a DATA workbook (usually closed) and update with the new records added. That is User1 enters data in DATA.xls User2 opens MAIN.xls and can update his MAIN.xls with any new records added in DATA.xls.
Long story short, I’m not proficient enough to get good Access environment set up and using the same workbook causes all sorts of problems as Users will or might be using simultaneously.
I tried the import query but it always overwrites the existing data, I just want it to add new records only.....
Any suggestions or help ?
