P3 intergration with access

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.

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.

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.

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

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??

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.

There is a sample Access file on CD, under folder RASampleAccess*.MDB. You can have that file as a start.