Problems while using JDBC-ODBC Bridge with Java 2

[wxdqz]

I am using JDBC ODBC bridge to access the Microsoft Access databases. Sometimeswhen I query the tables(select * from xxx), I receive lesser number of recordsthan the actual number of records in the table. It is not returning the actualnumber of rows in the table always. It always varies. Could anybody tellme what could be the reson?.Also when I give a query shown below, it is not returning any row but itreturns a few rows when I run this query inside Microsoft Access. Thanksin advance to whoever rendering help for my problem...--------------SELECT *FROM Currencies INNER JOIN (UnitsOfMeasurement INNER JOIN ((((ProductListINNER JOIN ProductGroup ON [ProductList].[GroupID]=[ProductGroup].[GroupID])INNER JOIN ProductClassification ON [ProductGroup].[GroupID]=[ProductClassification].[GroupID])INNER JOIN ProductBrand ON ([ProductClassification].[GroupID]=[ProductBrand].[GroupID])AND ([ProductClassification].[ClassificationID]=[ProductBrand].[ClassificationID])AND ([ProductGroup].[GroupID]=[ProductBrand].[GroupID])) INNER JOIN ProductModelON ([ProductBrand].[GroupID]=[ProductModel].[GroupID]) AND ([ProductBrand].[ClassificationID]=[ProductModel].[ClassificationID])AND ([ProductBrand].[BrandID]=[ProductModel].[BrandID]) AND ([ProductModel].[GroupID]=[ProductList].[GroupID])AND ([ProductModel].[ClassificationID]=[ProductList].[ClassificationID])AND ([ProductModel].[BrandID]=[ProductList].[BrandID]) AND ([ProductModel].[ModelID]=[ProductList].[ModelID])AND ([ProductGroup].[GroupID]=[ProductModel].[GroupID])) ON [UnitsOfMeasurement].[UnitID]=[ProductList].[UnitOfMeasurement])ON [Currencies].[CurrencyID]=[ProductList].[SellingCurrency]WHERE companyid=50ORDER BY [productlist].[groupid], [productgroup].[description];---------------Thanks,Syed.