I am trying to build some custom analytics from CHEMPAX, which for lack of a
better description is an ERP for Manufacturing and uses an Access Database as
the source.

Any one know how to derive the structure of the database. I have tried to
reverse engineer the database using Visio, but no primary keys or foreign key
relationships to give me a head start.

Sanj

Have you opened the db in Access and used Tools | Analyze| Documenter?

Good luck

Jeff Boyce
<Access MVP>

"Sanj" <(E-Mail Removed)> wrote in message
news:678EB1C8-3EA3-44CF-A9B7-(E-Mail Removed)...
>I am trying to build some custom analytics from CHEMPAX, which for lack of
>a
> better description is an ERP for Manufacturing and uses an Access Database
> as
> the source.
>
> Any one know how to derive the structure of the database. I have tried to
> reverse engineer the database using Visio, but no primary keys or foreign
> key
> relationships to give me a head start.