Query does not allow new records: OLEDB vs ODBC in Access 2K
The following two queries seem identical to me with the exception that the
first uses linked ODBC SQL Server tables and the other is an OLEDB Access
project linked to the same SQL Server tables. The first query will allow new
records to be added, while the second one won't. Has anyone any ideas about
what I can do to get the OLEDB query to accept new records?
Thanks,
Gary
SELECT dbo_tblMeanCatApply.MCApplyID, dbo_tblMeanCatApply.MeaningID,
dbo_tblMeanCatApply.MeanCatID, dbo_tblMeanCat.Category
FROM dbo_tblMeanCatApply
INNER JOIN dbo_tblMeanCat
ON dbo_tblMeanCatApply.MeanCatID = dbo_tblMeanCat.CatigoryID;
SELECT tblMeanCatApply.MCApplyID, tblMeanCatApply.MeaningID,
tblMeanCatApply.MeanCatID, tblMeanCat.Category
FROM tblMeanCatApply
INNER JOIN tblMeanCat
ON tblMeanCatApply.MeanCatID = tblMeanCat.CatigoryID
The second (OLEDB) query with only tblMeanCatApply *will* accept new
records, *until* I join it with tblMeanCat; then it won't. Yet adding
tblMeanCat to the second (ODBC) query *does* allow new records. Why?
Both are Access 2000 files linked to the same SQL Server tables. I'd like to
use the OLEDB Access project for the greater efficiency over ODBC and
because ODBC introduces the update bug when adding new records.
