data tranfer to/from P3 to MS Access

There ia a MsAccess file on the CD which can link to P3 by RA also.
It performs same as XLS.

Hello,

I’ve found the file from the cd.
\P3\Ra\samples\access\PRIMAVER.MDB

there is no documentation with it.
moreover, some stuff dont work in the file.
I did get the activity table. but not the CUSTOMCDI.
it gives an error: 3315 Field ’activityCDI.value’ cannot be zero-length string.

what could be wrong? any clues?

Gün.

The file is running on Access verion 97.

I don’t have a copy of P3 with me so I am guessing here. You need to go to Tools, Updata Data Dictionary and select Advanced. This will make your custom data fields available for RA to use.

Don’t know if this will solve your problem, but I think you would have to do this anyway.

Cheers

Why not export to a dbf file, this can be read directly by MsAccess

If you want to link P3 data into MS Access you have to install an ODBC driver that works with 16 bit data.
Doing so, ou can use P3 data directly in MS Access.
But you have to know how some things work, Otherwise it will crash instantly.