If you are not the world's greatest programmers, I'd strongly recommend you abandon this approach. It will not be straightforward. Go ahead and look at the revisions tables and see that there are large text fields that contain data serialized by php's serialize function, and that's just this tip of the iceberg in terms of complexity you will encounter. You are basically facing rewriting drupal and some of PHP in Access! This is not simple stuff. Also Earnie is right that you be failing to fire the required hooks if you operate on the database tables directly, so the features that you talk about in drupal will not really be available to you.
I would strongly recommend give the other approach more serious consideration. If you run into trouble there you are much more likely to get meaningful and helpful support from the drupal community on this endeavor.
Dave
.
________________________________
From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Wipe_Out Sent: Thursday, June 07, 2012 9:57 AM To: support@drupal.org Subject: Re: [support] Create and manage content directly from the database.
On 7 June 2012 17:24, Earnie Boyd earnie@users.sourceforge.net wrote:
On Thu, Jun 7, 2012 at 11:22 AM, Metzler, David metzlerd@evergreen.edu wrote:
Unless I misunderstand this question he's asking about how to create nodes in a mysql database using MS access as the development tool.
The
nodes he's asking to create are CCK crafted nodes in drupal.
He is asking how to update the tables created by the MSACCESS tool in an external MySql DB. You can connect to the external DB with Drupal and use Drupal to display and update the data. You don't need to create Drupal nodes to do that.
@Ernie - That was where we started but since we are not the worlds greatest programmers we are looking to switch it the other way around and get MS Access to work on the Drupal tables.. This way we can use "Views", "Rules", "References" and all the other available Drupal functionality as well..