You might consider using a project I created called Forena. It's report writing software and can report directly against tables in drupal or other databases. In this fashion you could display the booking data directly without having to try and create nodes from an MS access database.
It would probably be easier to write a custom drupal module to update the booking table structures than to get MS access to create nodes in drupal. The primary problem is that you'd have to be rewriting much of the cck logic in Access which seems like a lot of work, not no mention some data structures in drupal are serialized php objects, so there would be a lot of parsing code that would need to be written for this. There are no non-php apis.
Creating php code to update a booking structure in drupal on the other hand seems really straightforward to me. I do this kind of development work in drupal all the time.
________________________________
From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Wipe_Out Sent: Thursday, June 07, 2012 1:47 AM To: support@drupal.org Subject: [support] Create and manage content directly from the database.
Hi,
I am creating a booking management application and the bookings are largely generated and managed from a MS Access front end working directly on a MySQL database.. Now we need to integrate these bookings into the Drupal website so that users can add or update bookings for themselves..
I have created a content type with the required fields and now need to work out how to create content directly with SQL from MS Access..
Has anyone ever created content this way or have any idea which tables need records created/updated??
Unfortunately the system needs to be able to be updated from the Drupal site and from the MS Access application so imports and feeds won't work..
Thanks for any ideas or help..