ΛΛЯi arquitectos | ΛΛЯi architects

ΛΛ

Яi

AR

QU

ITEC

TO

S

P6R8.3

.2_W

ork

ingW

ithP6SD

K&Access_0.1

a

© 2

014 b

y Λ

ΛЯi ARQ

UIT

ECTO

S |

ΛΛЯi ARCH

ITECTS [2

014-0

2-1

4]

Primavera P6 R8.3.2 Working with P6SDK and MS Access

Open Setup Wizard….

Into advanced options, select as well > Software Development Kit [SDK]

ΛΛЯi arquitectos | ΛΛЯi architects

ΛΛ

Яi

AR

QU

ITEC

TO

S

P6R8.3

.2_W

ork

ingW

ithP6SD

K&Access_0.1

a

© 2

014 b

y Λ

ΛЯi ARQ

UIT

ECTO

S |

ΛΛЯi ARCH

ITECTS [2

014-0

2-1

4]

Check OS configuration… Control Panel

And select > Administrative Tools > Data Sources (ODBC)

From the ODBC Data Source Administrator go to System DSN tab

After SDK installation, must be shown an accessing in the Primavera P6 Professional SDK data source.

ΛΛЯi arquitectos | ΛΛЯi architects

ΛΛ

Яi

AR

QU

ITEC

TO

S

P6R8.3

.2_W

ork

ingW

ithP6SD

K&Access_0.1

a

© 2

014 b

y Λ

ΛЯi ARQ

UIT

ECTO

S |

ΛΛЯi ARCH

ITECTS [2

014-0

2-1

4]

Go to Configure bottom and check ODBC Name & Description:

Now you are ready to open Primavera´s Tablespaces into MS Access.

Open MS Access and create a Blank Database:

Go to External Data tab. an select import from ODBC Databases…

ΛΛЯi arquitectos | ΛΛЯi architects

ΛΛ

Яi

AR

QU

ITEC

TO

S

P6R8.3

.2_W

ork

ingW

ithP6SD

K&Access_0.1

a

© 2

014 b

y Λ

ΛЯi ARQ

UIT

ECTO

S |

ΛΛЯi ARCH

ITECTS [2

014-0

2-1

4]

Select from the screen > Link Tables… option

In Machine Data Source tab > select your P6 Professional SDK data source [PMSDK]

ΛΛЯi arquitectos | ΛΛЯi architects

ΛΛ

Яi

AR

QU

ITEC

TO

S

P6R8.3

.2_W

ork

ingW

ithP6SD

K&Access_0.1

a

© 2

014 b

y Λ

ΛЯi ARQ

UIT

ECTO

S |

ΛΛЯi ARCH

ITECTS [2

014-0

2-1

4]

To log on into MS Access….

When prompted to log in, login as ….. Use the same user/pass than you use to open Primavera P6 client..

Logon-screen to access into P6BBDD from MS Access Logon-screen to access into Primavera P6 client

Finally select desired tables you want to check, modify, link to, recover data… [as a forensic tool]..

ΛΛЯi arquitectos | ΛΛЯi architects

ΛΛ

Яi

AR

QU

ITEC

TO

S

P6R8.3

.2_W

ork

ingW

ithP6SD

K&Access_0.1

a

© 2

014 b

y Λ

ΛЯi ARQ

UIT

ECTO

S |

ΛΛЯi ARCH

ITECTS [2

014-0

2-1

4]

Project_short_name : PROD00914-a

ΛΛЯi arquitectos | ΛΛЯi architects

ΛΛ

Яi

AR

QU

ITEC

TO

S

P6R8.3

.2_W

ork

ingW

ithP6SD

K&Access_0.1

a

© 2

014 b

y Λ

ΛЯi ARQ

UIT

ECTO

S |

ΛΛЯi ARCH

ITECTS [2

014-0

2-1

4]

Project_short_name modified…. Into MS Access

Project_short_name : PROD00914

End..