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.

ODBC Link to Microsoft Access

5 replies [Last post]
Sun, 2006-09-17 20:56
Gillan Lam
User offline. Last seen 17 years 44 weeks ago. Offline
Joined: 17 Sep 2006
Posts: 8
Groups: None
Dear All,

Anyone can help to link P3 with MS Access though ODBC driver.

I remember there is a topic on this subject long time ago but now is no longer available.

Thanks in advance

Gillan
pit Consultant
Integration is the Key
Top

Replies

Thu, 2006-09-21 12:07
#1
Morph T
User offline. Last seen 17 years 30 weeks ago. Offline
Joined: 8 Aug 2006
Posts: 55
Groups: None
hi

thanks hashim , the link provided by paul is outdated i think

morph
Top
Thu, 2006-09-21 00:42
#2
Gillan Lam
User offline. Last seen 17 years 44 weeks ago. Offline
Joined: 17 Sep 2006
Posts: 8
Groups: None
Paul

I follow the link but cannot download the document.

Any chance to send me the document in the following address

gillanlam@pitconsultant.com

Thanks in advance

Gillan
Top
Thu, 2006-09-21 00:39
#3
Hashim Muhammud
User offline. Last seen 12 years 8 weeks ago. Offline
Joined: 7 Mar 2004
Posts: 38
Groups: None
Thanks a lot Paul..

Anyway, I found the driver in the following address. Thank a lot again...

ftp://suppsaleserver.primavera.com/odbc

Cheers

Top
Wed, 2006-09-20 08:59
#4
Paul Harris
User offline. Last seen 1 year 21 weeks ago. Offline
Joined: 11 Apr 2001
Posts: 618
Groups: Content Moderators, GPCCAR Editors
There is an article on my website under technical articles.

Paul E Harris
Eastwood Harris Pty Ltd, Melbourne, Australia
Planning and Scheduling Training Manual & Book Publishers & Consulting
www.eh.com.au
Top
Mon, 2006-09-18 06:45
#5
Hashim Muhammud
User offline. Last seen 12 years 8 weeks ago. Offline
Joined: 7 Mar 2004
Posts: 38
Groups: None
hi Gillan,

You should have ODBC driver installed to get connected to the Btrieve database (which is the one used by P3). Unfortuantely i am not able to find one for you. Search in the internet for this. Once you have the odbc driver installed, then i think you can connect as normal odbc connections. also, you have to update the data tables after each update you made in P3.

Tools--> Update Data Table

I dont know what is the exact purpose of this for you. But i belive you want to make some programming in MS Access. Anyway, i will suggest import / export to excel (wk1 files) and then making an option in your program to import the data in this excel files to the program. i know its double time job, but i think it is more secure and the data will be up to date. I made some programs before like this way.

hope this will help you.

cheers
Top