Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

How to Link between P3 & Data Base Program

15 replies [Last post]
Mon, 2002-02-11 08:22
Ali Hamouda
User offline. Last seen 7 years 48 weeks ago. Offline
Joined: 3 Feb 2002
Posts: 109
Groups: None
Dear sir, Instead of using Export Import utility in the Primavera. we can use direct link to any Program such as :Access,Infomaker,Excel,or any data base program. In P3.program they suggest Infomaker(but we can do it by mean of any program like MS-Access). If you pleas give me the complete Procedure to do that link between Access and Primavera,So as we can Produce any Reprot we need by using Access Data Base. Also give me a suggesstion about how to load Infomaker from any website. Thank you for your Co-operation Awaiting for your reply Ali ----------------
Top

Replies

Mon, 2010-11-22 08:44
#1
christ mark
User offline. Last seen 13 years 21 weeks ago. Offline
Joined: 22 Nov 2010
Posts: 4
Groups: None

Thanks for the post,Its really very best and informative for all,I like it.

logo design | landing page design

Top
Mon, 2007-10-22 03:46
#2
Chachrist Srisuwa...
User offline. Last seen 15 years 22 weeks ago. Offline
Joined: 9 Jan 2007
Posts: 30
Groups: None
Hey, I forgot to ask you. How do you know or learn to program with P3 using VBA?
I learn from Excel file example. I wonder are there any documents? or I have to become a partner in order to get the documents.
Top
Mon, 2007-10-22 03:41
#3
Chachrist Srisuwa...
User offline. Last seen 15 years 22 weeks ago. Offline
Joined: 9 Jan 2007
Posts: 30
Groups: None
Thanks for the offer. I sure will contact you when I need help. Rightnow, I just focus on MS Project. BTW, you can contact me directly at christ_cv@hotmail.com.
I just curious, where AutoCAD VBA fit into the picture (i mean your software). It has been awhile I didnt program in AutoCAD. Now I feel sorry for all those AutoCAD VBA books (3 books i guess) I bought long time ago.
Top
Mon, 2007-10-22 02:25
#4
Hannes de Bruyne
User offline. Last seen 1 year 31 weeks ago. Offline
Joined: 25 Jul 2005
Posts: 154
Groups: None
Hello Chachrist Srisuwanrat

as I’m working a lot with P3 and VBA, I would be interested in this Program you made. My addres is
Hannes.de-bruyne@hochtief.de. If your’ interested in my programms (translate MS-project to p3 and backwards) let me know. Finaly I found somebody who knows something about this method.
Top
Sun, 2007-10-21 00:08
#5
Chachrist Srisuwa...
User offline. Last seen 15 years 22 weeks ago. Offline
Joined: 9 Jan 2007
Posts: 30
Groups: None
using VBA, however, i am not sure about Stadd pro.But between, p3, AutoCad, Excel, or Access, it is possible.I did a small program geting and computing data from p3, AutoCad, and Excel long time ago.
:) hmm is it too late to reply this post?
should i ignore a very old post?
Top
Mon, 2005-11-21 14:41
#6
yousif alaubidi
User offline. Last seen 2 years 17 weeks ago. Offline
Joined: 18 Nov 2005
Posts: 55
Groups: None
Dear all
thanks for your letters on import & export method in primavera p3

But, any one can tell me with details how to make a like primavera p3and Autocad 2004 os excel or Staad pro 2004

with best regreds
Top
Tue, 2004-11-30 05:40
#7
Andrew Podolny
User offline. Last seen 40 weeks 5 days ago. Offline
Joined: 16 Nov 2004
Posts: 130
Groups: Petro-Chem / Oil & Gas
2 BIPRESH PAUL :
Hi, Paul.
I’ve used a very usefull tech tip from Paul Harris site:
http://www.eh.com.au/technical_papers.htm
This is self explanatory document. So I’m sure you won’t have any difficulties to link the database.
If you’ll have any questions don’t hesitate to contact me.
Best regards,
Andrew
Top
Tue, 2004-11-30 03:06
#8
BEEPEE PAUL
User offline. Last seen 19 years 18 weeks ago. Offline
Joined: 6 Jan 2004
Posts: 16
Groups: None
When i tried to enter ftp.primavera.com it’s asking for a name and password....Could nebody suggest how to get into the ftp of Primavera....and then download or if ne1 have the driver/exe file can u send it to the mail given"bpaul2404@hotmail.com"....Bye Bye
Top
Wed, 2002-04-24 09:08
#9
Forum Guest
User offline. Last seen 2 years 27 weeks ago. Offline
Joined: 28 Jan 2009
Posts: 1
Groups: None
can i know that how to log in the ftp.primavera.com for download the file? is it we need user name and password? thank you.
Top
Sat, 2002-03-23 13:34
#10
Robin Jongen
User offline. Last seen 16 years 12 weeks ago. Offline
Joined: 15 Mar 2002
Posts: 23
Groups: None
Make sure in P3 that the activitycodes do not have abriviations like SUM, SS, AS, ES because if you open the database in Access you will not see the information on the activity table. See bulletin 200112512824 knowledgebase primavera Reagrds,
Top
Wed, 2002-03-20 09:57
#11
Han Pekelharing
User offline. Last seen 12 years 1 week ago. Offline
Joined: 1 Oct 2001
Posts: 25
Groups: None
The version has a problem with the basic installed versions of ms access 2000. From a microsoft tech-page it is indicated that you need the access vulnerability patch which can be retrieved from the microsoft support pages. This updates the security and jet engine of access. After this update the ODBC link works fine and no conflicts occur. We can even have both Access and P3 open at the same time and do modifications, the only thing is that after a modification in Access, P£ has to be reorganised to see the result.
Top
Sun, 2002-03-10 09:42
#12
Mohd Mahd
User offline. Last seen 16 years 13 weeks ago. Offline
Joined: 13 Jul 2001
Posts: 62
Groups: None
thanks for the correction. my question, did u try using the version u mentioned? sometime ago, i tried some version (i am not sure if it is the same) and was not stable one, ie, it cuased ms access to hang, and u can't really work with ur project tables.
Top
Sat, 2002-03-02 13:02
#13
Han Pekelharing
User offline. Last seen 12 years 1 week ago. Offline
Joined: 1 Oct 2001
Posts: 25
Groups: None
The correct name is Pervasive and they supply the odbc driver for the link between MS-Access 2000 en Primavera's Btrieve database. The latest drivers are found on the ftp.primavera.com site under the odbc section. The file is called od32v204.exe. After download and install you have to make sure you have the latest access updates installed, otherwise the odbc connection won't work correctly. You can read the Primavera Knowledge Base for further details on this subject. It works fine under W95/98 but we found some problems under W2000 and are still trying to solve them, so any help?
Top
Thu, 2002-02-28 08:05
#14
Mohd Mahd
User offline. Last seen 16 years 13 weeks ago. Offline
Joined: 13 Jul 2001
Posts: 62
Groups: None
well, yes, ODBC is the method, but it is a special one from Prevasive Software (if i remeber the name correct). with which, u can creat the link u need with MS Access. regards, mohd
Top
Wed, 2002-02-27 05:28
#15
MK TSE
User offline. Last seen 3 years 46 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
The are 2 methods to link P3 and MS Access. By ODBC, the linkage method was simple. Update the directory in P3; Establish the link in Control Panel ODBC; Make link table in Access. The disadvantage was slow. By RA, sample files was in P3 CD. Infomaker was available on P3 CD also. I observed the establish the linkage was too complex. Sincerely, MK TSE
Top