Access 2002 vs 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Erik Vandamme - 22 Jan 2007 12:19 GMT

The query below works in acess 2002 but not 2003???
In fact it is worse in the query below it is the Cstr$ that causes the
problem

INSERT INTO JapanImpByMonth ( YearMM, Country, HS, Quantity, Yen, USD,
[Month] )
SELECT [Year]*100+1 AS Expr3, qJapanImportKate.CountryName,
qJapanImportKate.HS, qJapanImportKate.[Quantity2-Jan],
qJapanImportKate.[Value-Jan], [Value-Jan]*0.5 AS Expr1,
'Jan-' & Right$(Cstr$([Year]),2) AS Expr2
FROM qJapanImportKate;

Erik Vandamme wrote:

> In 2003 it has: Office11.0 Object Library and DAO 3.6 that does not work
> In Office 2002 same but it works, unfortunately client has 2003
> Is this a matter of no newer DAO libary? (being deprecated perhaps)

Reply to this Message

Douglas J. Steele - 22 Jan 2007 13:48 GMT

Did you try to repair your references, as I suggested elsewhere?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> The query below works in acess 2002 but not 2003???
> In fact it is worse in the query below it is the Cstr$ that causes the
[quoted text clipped - 12 lines]
> > In Office 2002 same but it works, unfortunately client has 2003
> > Is this a matter of no newer DAO libary? (being deprecated perhaps)

Reply to this Message

Erik Vandamme - 22 Jan 2007 20:04 GMT

for sure

> Did you try to repair your references, as I suggested elsewhere?

Reply to this Message

Erik Vandamme - 23 Jan 2007 03:52 GMT

Conclusion expression Cstr$() has been deprecated and Cstr() remain
neat that even the Converter does not notice this, so have to examine
all queries by hand...

> Did you try to repair your references, as I suggested elsewhere?

Reply to this Message