R
Ralph
An outsider vendor has set up a billing program which uses a SQL2000
database. They have set up views in this, and insist I use the views
for making reports and not the tables. They also insist that I use
Crystal Reports (which I don't know and don't own) to create the
reports. I would prefer to use Access2000 which I do know, but
because of this policy they refuse to give me any help in linking with
Access.
How do I link to the SQL views from Access? I have read everything I
could find but can't seem to find this detail.
Ralph
database. They have set up views in this, and insist I use the views
for making reports and not the tables. They also insist that I use
Crystal Reports (which I don't know and don't own) to create the
reports. I would prefer to use Access2000 which I do know, but
because of this policy they refuse to give me any help in linking with
Access.
How do I link to the SQL views from Access? I have read everything I
could find but can't seem to find this detail.
Ralph