INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...My thanks to the contributors who freely share their knowledge and enthusiasms. This forum restores some measure of my faith in human nature..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Enterprise Applications > ERP and CRM Solution Vendors > MAS 90 (Sage) solutions Forum

ODBC from mas 90 to Access

Read More Threads Like This One

JustinaJ (Programmer)

8 Mar 02 3:44

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 (TechnicalUser)

12 Mar 02 15:13

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 (TechnicalUser)

17 Jan 03 13:00

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 (Programmer)

24 Feb 03 1:59

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 (Programmer)

24 Feb 03 2:01

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

-- DrFrank

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To MAS 90 (Sage) solutions