ODBC from mas 90 to Access 1

[JustinaJ]

I am pretty sure it can be done but does anyone know how to get the data out of mas 90 and into access? Also is the data in Access read only? Thank you.
-Justina

 

[nomus1]

We do quite a bit of this.
Yes, the data is read only.
I recommend that for modules like invoice detail history you make a copy of the table to your local drive. We make nightly copies of several tables just to improve performance.

To link to the table
File
Get External Data
Link Tables
Change type to ODBC Databases
SOTAMas90 should be listed as an option

 

[drdebit]

Has anybody done this process with Lotus millenium versions.
Our software resellers have talked to us about this process with microsoft, but everybody just groans when I bring up Lotus.

 

[DrFrank]

I created the linked tables as nomus1 instructed, but I get the following error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'SOTAMAS90' failed.

Any ideas?

-- DrFrank

 

[DrFrank]

One addition -- I am attempting to access through an ASP page.

-- DrFrank