I am using JDBC ODBC bridge to access the Microsoft Access databases. Sometimes
when I query the tables(select * from xxx), I receive lesser number of records
than the actual number of records in the table. It is not returning the actual
number of rows in the table always. It always varies. Could anybody tell
me what could be the reson?.

Also when I give a query shown below, it is not returning any row but it
returns a few rows when I run this query inside Microsoft Access. Thanks
in advance to whoever rendering help for my problem...
--------------
SELECT *
FROM Currencies INNER JOIN (UnitsOfMeasurement INNER JOIN ((((ProductList
INNER 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 ProductModel
ON ([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=50
ORDER BY [productlist].[groupid], [productgroup].[description];
---------------


Thanks,
Syed.