[AccessD] Converting Access97 app to 2000

Several things.  If you ever played with pipe concatenation (if you
don't know what it is, you haven't), you'll have to change it to
standard concatenation because 2000 and higher don't interpret it
properly.  If you use parameter queries that reference forms, you'll
have to go into the queries and make sure the query parameters use
proper referencing like [forms]![MyForm]![MyControl].  If any of the
brackets around any of the sections are missing, 2000 and later will put
brackets around the whole thing, like [forms!MyForm![MyControl]], which
breaks the query.  Using @ in messagebox prompts to bold parts of the
text no longer works in 2000+, so you'll have to deal with that if you
used it.

If you used any common controls (calendar controls, datetime picker,
OpenFile dialog, etc.) you'll need to make sure the references point to
the VB6 version, becase the VB5 versions don't work in 2000+.

Charlotte Foust


-----Original Message-----
From: Tony Septav [mailto:iggy at nanaimo.ark.com] 
Sent: Tuesday, June 07, 2005 10:20 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Converting Access97 app to 2000


Hey All

I have converted my first Access97 application to Access2000. Everything

seems to be working fine.  I have not as yet gone through and changed my

declarations to DAO.Recordset, DAO.Database, etc..  Are there any other 
things I should be aware of.?

And I know some of you are saying "Geez about time".
I am planning on purchasing Access2003, but one step at a time, it is 
hard to teach an old dog new tricks.
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com