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.

P3 intergration with access

7 replies [Last post]
Sat, 2004-03-13 09:43
Dinesh Kumar
User offline. Last seen 7 years 20 weeks ago. Offline
Joined: 3 Jan 2004
Posts: 37
Groups: None
Hi Guys,

Anybody intergrated P3 and access? How it goes?

I appreciate if you can advice how to set up and how the regular updating can be done using access.

( I have read Mr.Paul papers and managed to link)

Thanks & regards

Dinesh
Top

Replies

Wed, 2004-04-07 07:17
#1
Luca Basile
User offline. Last seen 10 years 32 weeks ago. Offline
Joined: 10 Jul 2003
Posts: 288
Groups: TILOS
Have You try P3e?
I know that P3 is using Btrieve database engine, while P3e should use Oracle!

This change should allow You to manage a bigger quantity of informations in a faster way.
I wonder if it should be better also the integration with Sap or other Oracle application like COnvero and so on.

Actually I am not working with P3e, so I did not yet real try to see the whole benefits.

If You have it, let me know.
Top
Wed, 2004-04-07 01:34
#2
Luca Basile
User offline. Last seen 10 years 32 weeks ago. Offline
Joined: 10 Jul 2003
Posts: 288
Groups: TILOS
The problem with Access is not just with RA.
Is a basic one, as Microsoft look like change a little bit the Vba for access.
So You have to learn it almost from scratch.

Top
Tue, 2004-04-06 12:01
#3
MK TSE
User offline. Last seen 5 years 16 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
For 3 methods, I choose the third one: Export/Import only.

For RA, since it is in Access97 version, I cannot make it work in Access 2000 and give up.
For ODBC, since the communication is too slow. If the P3 project is a ’big’ programme, always time out.
So I export all required P3 data to dbf and auto-import to Access 2000. Then it will be transform into required format and layout bu macro.
Top
Tue, 2004-04-06 06:20
#4
Luca Basile
User offline. Last seen 10 years 32 weeks ago. Offline
Joined: 10 Jul 2003
Posts: 288
Groups: TILOS
Mainly You can do in three different way:
1 - With RA prepare a routine that is reading from P3 teh info and then coping back;
2 - With ODBC (Btrieve or Pervasive) with a "live" link between P3 and access or excel (MsOffice);
3 - Exporting from P3 tables that You will process in access with Your query, form and report. Then import back all.

All are working, but they have some limits.

I found out that if I am using the ODBC drivers to link P3 and MsOffice, when I am using it with access I can not update P3 or vice versa.
This is because they are working at the same database.

Using RA I have not this problem as I do not establish a "live" link, but I just pick up or puting back the info when I want. But You have to know a programme language in this case Vba and how RA is working.
This can take time and effort.

The last chance is easier one as require just the knowledge of access, so prepare Your form for updating, some query and standard report to help in the weekly and monthly report issue.

Now is up to You.

Luca
Top
Tue, 2004-04-06 02:09
#5
Forum Guest
User offline. Last seen 1 year 8 weeks ago. Offline
Joined: 28 Jan 2009
Posts: 2
Groups: None
I also have gone through Mr. Paul’s article..But that, I think that is considering version 3.0 of P3 ..
I tried to follow the steps in version 2.0.. It does not work..Also I find when I go by menu "Tools"then
"update data dictionary", it does not create index.dbf, and other .dbf files, rather shows "AIT" and "RIT" files are created,
although I don’t find it nowhere..

I have tried linking through "ODBC", that comes along with version 2.0, to convert into Access or excel
tables (office 2000),but did not work..

Can anyone help me in this regard??

Top
Sun, 2004-03-14 05:26
#6
Zq qz
User offline. Last seen 13 years 36 weeks ago. Offline
Joined: 6 Jun 2003
Posts: 163
Groups: None
You can do this by Import and Export option from p3. In access Do some update query command, to update link data from primavera .dbf file.
Top
Sat, 2004-03-13 21:36
#7
MK TSE
User offline. Last seen 5 years 16 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
There is a sample Access file on CD, under folder RASampleAccess*.MDB. You can have that file as a start.
Top