link to SQL View

[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

 

[Rick Brandt]

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.

Assuming you have proper permissions to them you link to Views in exactly
the same manner as you link to Tables. In fact while creating the link the
wizard doesn't even distinguish between Tables and Views. It just lists
them all together.

 

[Van T. Dinh]

You can link Views to Access and the Views will appear as "Linked Tables" in
Access just link SQL Tables.

If you have proper permission to Views, you don't need to have access to the
SQL Tables.

Once you link the Views, you can use Access Reports.

 

[Ralph]

You can link Views to Access and the Views will appear as "Linked Tables" in
Access just link SQL Tables.

If you have proper permission to Views, you don't need to have access to the
SQL Tables.

Once you link the Views, you can use Access Reports.

I thought that should be the case, but I must have something set wrong
because the tables show up, but the views don't.

Ralph

 

[Rick Brandt]

I thought that should be the case, but I must have something set wrong
because the tables show up, but the views don't.

I believe when you don't see objects while going through the ODBC link wizard it
is generally because you don't have select permissions to them.