data tranfer to/from P3 to MS Access

G
Gün Göksu 👤 Member for 21 years 2 months
C
Cor de Bakker 👤 Member for 20 years 10 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.

K
Kevin Button 👤 Member for 22 years 10 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

G
Gün Göksu 👤 Member for 21 years 2 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.

M
MK TSE 👤 Member for 24 years 3 months

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

It performs same as XLS.

Forum Sponsor

Top Posters

Dimitrios Theocharidis
3 posts
MichaelFuelsC
0 posts
anwar zeb
1 posts
olva seselima
1 posts
Muhammd Muneer
0 posts
sairam
0 posts
MARAT BILYALOV
0 posts
RichTea66
0 posts
Muneer Muhammad
1 posts
Manny Onifade
5 posts