Link a view in MSaccess

--------------050405020902000100080803
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit


Hello all:

I'm trying to link views to MS Access, but it seem not work fine. If I
link a view that has two or more tables in the query and after open the
view, I only see fields of one table.

I have been looking for at the documentation, an entry of linking views
in Access, but I have not success. Somebody could answer me whether it
works or no, and if work what I would to do?.

Thanks a lot in advance. Best regards,

Josemi



--------------050405020902000100080803--

Re: Link a view in MSaccess

--------------080300010803040009030908
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable


Hello all:

Thanks Kishore for your help. The views work fine from 'MySQL Query=20
browser' then I afraid your suggestion seems it's doesn't the problem.

Sorry, but I had forgotten the program versions. I going to explain now:

- Server: RH9 with MySQL 5.0.24a
- Client : Windows Xp Professional+MSAccess 2000+MyODBC 3.51.12

Regards,

Josemi

----------------------------------

Kishore Kumar Barik escribi=F3:
> Look I think there is some problem in joins in query. At you chek the=20
> joins or innder queries of different views. then again these view.=20
> except this I cannot say the solution because I dont know your actual=20
> schema. But there is no problem in joining the views.
> =20
> kishore
>
> =20
> On 9/18/06, *Jos=E9 Miguel Serrano* > > wrote:
>
>
> Hello all:
>
> I'm trying to link views to MS Access, but it seem not work fine. I=
f I
> link a view that has two or more tables in the query and after
> open the
> view, I only see fields of one table.
>
> I have been looking for at the documentation, an entry of linking
> views
> in Access, but I have not success. Somebody could answer me whether=
it
> works or no, and if work what I would to do?.
>
> Thanks a lot in advance. Best regards,
>
> Josemi
>
>
>
>

--------------080300010803040009030908--

RE: Link a view in MSaccess

Although I have not used views, I tried this and it happens for me too. =
I can only see the fields in one of the tables included in the view.

John Bonnett=20

-----Original Message-----
From: Jos=E9 Miguel Serrano [mailto:jmserrano@ain.es]=20
Sent: Monday, 18 September 2006 4:26 PM
To: 'myodbc'
Subject: Link a view in MSaccess


Hello all:

I'm trying to link views to MS Access, but it seem not work fine. If I =
link a view that has two or more tables in the query and after open the =
view, I only see fields of one table.

I have been looking for at the documentation, an entry of linking views =
in Access, but I have not success. Somebody could answer me whether it =
works or no, and if work what I would to do?.

Thanks a lot in advance. Best regards,

Josemi



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg