thread637-1405340
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
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