data tranfer to/from P3 to MS Access

Member for

20 years 2 months

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.

Member for

22 years 3 months

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

Member for

20 years 7 months

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.

Member for

23 years 8 months

There ia a MsAccess file on the CD which can link to P3 by RA also.

It performs same as XLS.