Hi!
This is not quite easy things to do, there are few tricky parts, but I think it is possible to do. There is a way to create a link to Google calendar and that will work in two way - actually it will be a single table. The question is: do we need to sync appointments with another Access table?
I am willing to step in before we officially start the project. Let me know can you share with me your database. It does not need to contain any real data. You can make a copy and remove real data leaving one dummy record in each of the tables. Tomorrow I'll work on it, to create a link and then I'll let you know what can be done about it and how.
If you agree with above, send me a file. I will not reply, here is quite late, but I'll send you an update tomorrow!
Thanks!
Regards,
Branislav Mihaljev