Unanswered: Access 2007 and SharePoint 2007 calendars
I have been trying to automate the updating of a 2007 SharePoint calendar from within Access.
Within SharePoint, I clicked the actions then 'Open with access'. I copied the calendar to an existing 2007 dbase. It inserted to tables, both associated with the calendar. I can click on the calendar table and edit the fields and then resync the table and it updates SharePoint with no problem. When I try to take data from a form and update the calendar table, access states it can't find the table. The table DOES NOT apprear in the linked table manager within Access even though the icon shows it as a linked table.
My question is, how can I edit/update the calendar table from within a form.
Have been working on this a few days. I am using a converted 2003 dbase which uses DAO.