Ms Project and MS Access

[weemien23]

Hallo everyone,

I am not so familiar with window programming. At the moment I am writing a PHP/MYSQL script and want to interact with MS Project.
I want to write a program(realtime) to export data from MS Project to MS ACCESS/MYSQL and back.
Is this possible?? If so how??

weemien

 

[PDQBach]

This cannot be done in real time.

The best you can do is set up a VBA macro that runs when you launch it. Sorry.

If you want help doing that, then you'll need to be a LOT more specific about the requirements: fields, timing, frequency, volumes (number of projects, numnber of tasks in the projects, number of resources, etc. (It would also be helpful if you explained why you want to use MySQL rather than one of the more capable products that are available.)

So let's take this one step at a time: what are you trying to accomplish? what fields do you want to export from Project? what fields do you want to import into Project?

 

[weemien23]

Thanks for the reply,
The thing is I have to make a construction management tool for a company. They work with MS Project and the info must be available online(PDA,laptop)
Sinds MSACCESS is not that powerfull for the web, we are going to use MYSQL.
MS PROJECT<->MS ACCESS<-> MySQL<->PHP

I guest I want all the tables because is always helpfull for later use. I started with a Macro that can save project in MS Access, but I don't want this to be done manually.
I am trying to figure out how to do this with a timer like every 2 min??
If you have idea's let me know.

weemien

 

[PDQBach]

Your initial requirement was for real time. Now it is for online.

I have _never_ been in an environment where plans have to be updated and distributed on a minute-by-minute environment. Furthermore, I cannot conceive of a situation where changes I am making to a plan need to be communicated every 2 minutes.

Even MS Enterprise requires you to make changes (essentially) offline and then to collaborate (i.e. publish) them so that others can see the changes.

You also mention a PDA. I have an ancient Handsping and it simply doesn't support online or realtime. I have to go through a manual synch process.

&quot;Online&quot; is NOT (most definitely NOT) the same as real time. Your inability to understand this suggests that you have completely misunderstood the overall requirement.

 

[weemien23]

I know what the differents are between online and realtime
The two databases must be synchronize realtime to stay consistent and the online part is more for the PHP files so that the people on the field can interact(updates) with a PDA(browser)
The 2 min is just an example.
I'm trying to build a macro with timer that save the data to Access.

 

[Storyteller]

Hello weemien23,

You did not mention what version of project your are using so here are two links you might find useful:

PRJ98: Microsoft Project 98 Visual Basic Environment Manual
Microsoft Knowledge Base Article - 186077

http://support.microsoft.com/defaul...port/kb/articles/Q186/0/77.ASP&NoWebContent=1

and

Microsoft Project 2002: VBA Help File
File Name: vbapj10.exe

http://www.microsoft.com/downloads/...57-a4ff-486f-9cfd-4b673dc2cbe9&DisplayLang=en

Have you looked into Project Central/Server?

Hope this helps,
Michael

 

[weemien23]

Thank you..
The links are very helpfull, I see how far I'll go.
Happy Holidays to everyone

weemien