Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

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.

Link Ms Access to P3

26 replies [Last post]
Tue, 2005-05-17 22:17
Daniel Jeyaraj Be...
User offline. Last seen 15 years 25 weeks ago. Offline
Joined: 19 Jan 2004
Posts: 16
Groups: GPC Malaysia, Petro-Chem / Oil & Gas
Guys,
Can I link Ms Access to P3? I am getting data from site which is updated in Ms Access, with has identical Activity ID no, Start & Finish dates and Act %, so if its possible to link the two, I dont have to do repetitive work to update activities in P3. Please advise.

Thank you.
Daniel
Top

Replies

Sat, 2005-11-12 00:29
#1
Rajesh Moolakkandam
User offline. Last seen 8 years 27 weeks ago. Offline
Joined: 5 Jun 2004
Posts: 15
Groups: Petro-Chem / Oil & Gas
Hello friends,

Can anybody send me latest version of PERVASIVE Driver.
When i installed ver 2.04, I am getting a message "Login must succeed before data source entry can mbe written" (Status code 802). Please advice,to rajesh_m@walla.com


Regards
Rajesh M
Top
Sat, 2005-11-12 00:01
#2
Rajesh Moolakkandam
User offline. Last seen 8 years 27 weeks ago. Offline
Joined: 5 Jun 2004
Posts: 15
Groups: Petro-Chem / Oil & Gas
Hello friends,

Can anybody send me latest version of PERVASIVE Driver.
When i installed ver 2.04, I am getting a message "Login must succeed before data source entry can mbe written" (Status code 802). Please advice,

Regards
Rajesh M
Top
Wed, 2005-11-09 02:49
#3
Wassem Habboub
User offline. Last seen 13 years 1 week ago. Offline
Joined: 13 Aug 2005
Posts: 7
Groups: None
Daya,

Can I have a copy of pervasive too?

My email is whaboub@yahoo.com

Thanks

Rgds
W.H
Top
Wed, 2005-10-05 21:16
#4
Zhang Haixiang
User offline. Last seen 4 years 8 weeks ago. Offline
Joined: 14 Apr 2005
Posts: 250
Groups: None
Daniel,
I don’t think it is a good to update P3 file using Access. To do this you need a very clear understanding of P3 data structure,otherwise you will input some invaid data,and make your file corrupt. I suggest to use RA instead, because RA will do some basic data checking. I use Access (informaker) & OBDC only for reporting, because they can generate more professional report than P3.

For your task, you do not need to make it so complex.
Just make a query in Access to include Act ID, Act Dur, rem dur ...what ever you want, then save this query as a DBF file, and then import it to P3. Make sure the field length is the same as P3 expected (e.g. description 48 char...)
Top
Tue, 2005-10-04 18:45
#5
Andy Parkes
User offline. Last seen 9 years 4 weeks ago. Offline
Joined: 1 Feb 2001
Posts: 16
Groups: None
So we now know how to link the data.

But I’m finding difficulty in updating activity data in Access and transfering those changes back to P3.

I’ve created the Access tables as Linked tables (rather than Imported), but when I change the data - Access tells me that:

"Write Conflict
This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user has made.
Copying the changes to the clipboard will let you look at the values the other user entered, and then paste your changes back in if you decide to make changes."

It doesn’t give me an option to "Save Record" (the option is disabled), just "Copy to Clipboard" or "Drop Changes"

So I just can’t do what I want to do.

Any advice?
Top
Sun, 2005-06-05 21:16
#6
Daniel Jeyaraj Be...
User offline. Last seen 15 years 25 weeks ago. Offline
Joined: 19 Jan 2004
Posts: 16
Groups: GPC Malaysia, Petro-Chem / Oil & Gas
Daya,

Can I have a copy of pervasive too?

My email is rhesan@yahoo.com

Thanks

Rgds
Daniel
Top
Sat, 2005-06-04 23:26
#7
Jaco Stadler
User offline. Last seen 18 years 6 weeks ago. Offline
Joined: 8 Sep 2004
Posts: 299
Groups: None
http://www.eh.com.au.

Have got a detailed method.


This has Also been discussed before will find the link is ">http://www.planningplanet.com/forum/forum_post.asp?Cat=2&Top=7181<?a>.

Please have a look at Daya Explanation it is a good tip for
Top
Sat, 2005-06-04 09:26
#8
Sunil Kumar
User offline. Last seen 8 years 35 weeks ago. Offline
Joined: 31 Mar 2005
Posts: 84
Groups: None
Gentlemen,
I have the ODBC and the Pervasive (Thanx Daya), can someone suggest a step by step way of linking p3 access. Would greatly apprecaite it.

Thanx

Sunil
Top
Thu, 2005-06-02 05:37
#9
Sunil Kumar
User offline. Last seen 8 years 35 weeks ago. Offline
Joined: 31 Mar 2005
Posts: 84
Groups: None
Thanks Daya,

Since I have High speed, i think it shouldnt be a problem

Cheers

Sunil
Top
Thu, 2005-06-02 05:34
#10
Dayanidhi Dhandapany
User offline. Last seen 3 years 35 weeks ago. Offline
Joined: 18 Mar 2003
Posts: 470
Groups: None
Sunil, The file is on the way to your inbox. Approx. 2.5 MB or so, it has to cope up with our internet traffic......so soon you will receive it(may be in another 20mints time???). Cheers!!! Daya
Top
Thu, 2005-06-02 05:27
#11
Sunil Kumar
User offline. Last seen 8 years 35 weeks ago. Offline
Joined: 31 Mar 2005
Posts: 84
Groups: None
Hellow Daya,

Awaiting your attachment with excitement.

Cheers


Sunil
Top
Thu, 2005-06-02 05:06
#12
Dayanidhi Dhandapany
User offline. Last seen 3 years 35 weeks ago. Offline
Joined: 18 Mar 2003
Posts: 470
Groups: None
Alex, Its my pleasure to help others.............
Top
Tue, 2005-05-31 22:29
#13
Alex Wong
User offline. Last seen 11 years 36 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
Daya

It seem that you becomes the favour of the months

Alex
Top
Tue, 2005-05-31 22:16
#14
Sunil Kumar
User offline. Last seen 8 years 35 weeks ago. Offline
Joined: 31 Mar 2005
Posts: 84
Groups: None
Hellow Dayanithi,

Please Can I have a copy of pervasive too. My email ID is rsunilr1@yahoo.co.in

Thanx

Sunil
Top
Tue, 2005-05-31 11:21
#15
Dayanidhi Dhandapany
User offline. Last seen 3 years 35 weeks ago. Offline
Joined: 18 Mar 2003
Posts: 470
Groups: None
Don, Leave me your email id to send the file or contact me at plannerdaya@yahoo.com
Top
Tue, 2005-05-31 09:43
#16
Zq qz
User offline. Last seen 12 years 46 weeks ago. Offline
Joined: 6 Jun 2003
Posts: 163
Groups: None
Gentlemen where I can get this Pervasive Driver.....
Top
Mon, 2005-05-30 03:02
#17
Frank Borcherdt
User offline. Last seen 7 years 50 weeks ago. Offline
Joined: 3 May 2001
Posts: 88
Groups: None
Assume you have P3 3.1 installed on the same machine so you have the btrieve microkernel files as well as the ODBC drivers.

I just loaded the ODBC drivers and was able to link and retrieve data using MS Access 2002 SP3 and an XP Pro SP2 machine with all Micrsoft critical patches loaded.

I used the P3 ODBC Manager to create the ODBC datasource.
Find at http://www.ecspl.com.au/support/odbc Copy to P3WIN folder, run it once without P3 running to add tool to Tools menu and then you can run from Tools menu in any open project to create the ODBC source.
Top
Sun, 2005-05-29 23:02
#18
Frank Borcherdt
User offline. Last seen 7 years 50 weeks ago. Offline
Joined: 3 May 2001
Posts: 88
Groups: None
Daniel,

Whilst ODBC does work it is much better to use Ra the P3 Object model mentioned by Dayanidhi if you intend to update P3. ODBC is great for reporting.

ODBC does not reference the business rules (autocost rules) and you need to perform ALL of the associated updates the P3 performs when you manually enter the data...if you miss some you will end up will data that does not make sense.

The Ra object model automatically does this for and can be found on you P3 CD.
Top
Sun, 2005-05-29 22:53
#19
Alex Wong
User offline. Last seen 11 years 36 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
Sunil

Yes MS Access work very well with P3 using ODBC. Of course you need to be a programmer if you want to make it more user friendly.

Cheers

Alex
Top
Sun, 2005-05-29 22:48
#20
Sunil Kumar
User offline. Last seen 8 years 35 weeks ago. Offline
Joined: 31 Mar 2005
Posts: 84
Groups: None
Hellow Dayanidhi,

Have you actually tried it and is it working perfectly ???

Top
Wed, 2005-05-18 03:58
#21
Daniel Jeyaraj Be...
User offline. Last seen 15 years 25 weeks ago. Offline
Joined: 19 Jan 2004
Posts: 16
Groups: GPC Malaysia, Petro-Chem / Oil & Gas
All,
Thnaks for the reply. Will check the link.

Daniel
Top
Wed, 2005-05-18 03:05
#22
Andrew Podolny
User offline. Last seen 1 year 20 weeks ago. Offline
Joined: 16 Nov 2004
Posts: 130
Groups: Petro-Chem / Oil & Gas
Daniel,

Check this thread
http://www.planningplanet.com/forum/forum_post.asp?fid=1&Cat=2&Top=64.
Top
Wed, 2005-05-18 02:25
#23
Dayanidhi Dhandapany
User offline. Last seen 3 years 35 weeks ago. Offline
Joined: 18 Mar 2003
Posts: 470
Groups: None
Daniel,

Certainly you can link MS Access to P3 using ODBC. Infact you can write your own programs using VBA in Access to communicate with P3 Objects and customize the things in your own way.

HTH

Daya
Top