Re: MS Project Backend?

Hi,

Personally to me the best way to have corrupted data is to modify Project's
data without any control, i.e. without opening Project.

If you modify Project's OBJECTS through VBA, for instance (rather than worry
about tables) Project will immediately react whan you enter something
impossible (like start, fiunish and duration that are not coherent, or a
circular link between tasks)

I admit this is a personal view (I know a lot about Project's objects, but I
can't even recognize a data base table when I see one). Most people know a
lot about all sorts of data bases and feel unhappy about Project modifying
that they have so scrupulously entered in their DB :-)

By all means, when you want to update Project's data without Project open,
saving to a DB is an option.
And any ODBC data bae will do. But don't be upset when after opening the
file by Project, some data will change!

HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"Stephen Moras" <StephenMoras@xxxxxxxxxxxxxxxxxxxxxxxxx> schreef in bericht
news:C5C26399-B403-4EE3-A6DA-DAA8686CFC08@xxxxxxxxxxxxxxxx
> Hi Jan,
>
> We have all our data in Excel. Rather then manually type all over again we
> want to automate the process. We want to programatically import the data
into
> MS Project thru Excel. We also want to control MS Project thru external
> means. In short we want to avoid opening MS Project as much as possible.
>
> Now to do all this we need to open MS Project. It has so many tables n
> fields tht its very likely to get corrupted if we dont enter the required
> data. Thus we belived tht inputting n contrlling thru MS Access was the
best
> way. Then we decided on MSDE as its free n no licencing issues n its
server
> based, so less load on clients machine.
>
> Thus the question..But then again since u r most likely an expert wud u
> agree with this method or do u have a better alternative?
>
> Cheers
> --
> Regards,
> Stephen
>
>
> "Jan De Messemaeker" wrote:
>
> > Hi,
> >
> > MS Project natively stores the data as .mpp files, a product specific
> > format.
> > You can through Save as choose between many alternatives:
> > mpd (Access indeed)
> > xml
> > through the ODBC button, any ODBC data base;
> > but I really wonder why you would force your users to each time go
through
> > this routine.
> > Millions of users save as .mpp by just doing Save.
> >
> > Unless of course you have other plans with the data.
> > HTH
> >
> > --
> > Jan De Messemaeker
> > Microsoft Project Most Valuable Professional
> > http://users.online.be/prom-ade/
> > +32-495-300 620
> > "Stephen Moras" <StephenMoras@xxxxxxxxxxxxxxxxxxxxxxxxx> schreef in
bericht
> > news:A80A98EB-CE48-41D5-BB41-0D82BC7A23AC@xxxxxxxxxxxxxxxx
> > > Hi Jan,
> > >
> > > Maybe i was not clear or maybe i have my info wrong. I am under the
> > > impression tht MS Project stores all its data in the backend as an
mpd(?)
> > > file..This mpd is actually an MS Access file (?) ..My company doesnt
want
> > to
> > > use MS Access but wants to use MSDE as its free n fast n reliable.
> > >
> > > If i am wrong then how & in what format does MS project store its
data?
> > > whats its backend?
> > >
> > > Thks
> > > --
> > > Regards,
> > > Stephen
> > >
> > >
> > > "Jan De Messemaeker" wrote:
> > >
> > > > Hi Stephen,
> > > >
> > > > When you do not use Project Server you need neither of those.
Nothing.
> > > > Project Server is based on SQL server only.
> > > > HTH
> > > >
> > > > --
> > > > Jan De Messemaeker
> > > > Microsoft Project Most Valuable Professional
> > > > http://users.online.be/prom-ade/
> > > > +32-495-300 620
> > > > "Stephen Moras" <Stephen Moras@xxxxxxxxxxxxxxxxxxxxxxxxx> schreef in
> > bericht
> > > > news:1206B08B-7BBA-45CF-BC06-E957B02D3582@xxxxxxxxxxxxxxxx
> > > > > Hi,
> > > > > I would like to use sql lite (as its free) as the backend for MS
> > Project
> > > > > rather then SQL Server (?) or MS Access.. Is it possible to do
so..If
> > yes
> > > > > then how or any documentation available?
> > > > >
> > > > > Thks
> > > > >
> > > > > Cheers
> > > >
> > > >
> > > >
> >
> >
> >


.