I have an Access database that currently connects to the SQLDEMO tables. That's great.

When I look at the server running D3, I see the SQLDEMO folder in the D3Databases folder. Fine

So now I want to connect to some live data. Specifically the inventory tables.

I have lots of documentation, but I can't seem to find the steps to make the tables visible to my odbc dsn.

The folder I think I am after is the MISPR folder.

If I'm correct, how do I get access to the values in the tables?

I was told I need to define a translation table..yes/no

Regards

I have an Access database that currently connects to the SQLDEMO tables. That's great.

When I look at the server running D3, I see the SQLDEMO folder in the D3Databases folder. Fine

So now I want to connect to some live data. Specifically the inventory tables.

I have lots of documentation, but I can't seem to find the steps to make the tables visible to my odbc dsn.

The folder I think I am after is the MISPR folder.

If I'm correct, how do I get access to the values in the tables?

I was told I need to define a translation table..yes/no

Regards