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

"...Thanks! Awesome group. I put out a simple question in the access/vba forum that I couldn't find answered on technet or anywhere else on the web and it was answered the same day!!..."

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

SQL Views to MAS 200 Database

Read More Threads Like This One

PriceDon (IS/IT--Management)

20 Sep 11 14:11

thread637-1405340: MAS200 ODBC connection string to Sharepoint

I have created an SQL linked server to my MAS200 database, this all works fine. I then created a blank database with a view to AP_Vendor. The SQL syntax I used to create the view was:
CREATE VIEW Vendors AS
SELECT * from OPENQUERY(MASLINK, 'SELECT * FROM AP_Vendor')

My problem is when I try an access the data, I don't see the view. I'm wondering if it has something to do with a no primary key.
Does anyone have any idesas?

Thank you
Don Price

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