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:
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..