"Views" for Microsoft Access database !!!

[daniorza]

When I try to select views in Microsoft Access database in a java application within jdbcdbc and the sql statement is "select Name from sysobjects where xtype = 'v'" I get this :

 [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'SYSOBJECTS'.  Make sure it exists and that its name is spelled correctly.

My driver is not good ?
How can I create a view ?
Thank you !!!

 

[nickjar2]

Try this

select Name from Msysobjects where xtype = 'v'

The table is called Msysobjects and not sysObjects.

Nick