Results 1 to 2 of 2
Thread: Upgrading from 97 to 2003 (2003)
2004-08-12, 22:33 #1
- Join Date
- Aug 2004
- Thanked 0 Times in 0 Posts
Upgrading from 97 to 2003 (2003)
The option to upgrade from 97 to 2003 is available to me. Are there a) any known conversion issues and [img]/forums/images/smilies/cool.gif[/img] any major bugs with the 2003 software?
2004-08-12, 22:47 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 Posts
Re: Upgrading from 97 to 2003 (2003)
Welcome to Woody's Lounge!
If you do a search in this forum for convert 97, you'll find numerous older threads dealing with the conversion from Access 97 to Access 2000/2002/2003. Some things to look for:
<UL><LI>Make implicit DAO declarations explicit (Dim rst As DAO.Recordset instead of ... As Recordset). Starting with Access 2000, there is a new data object model, ADO, while the original object model, DAO, still exists. Both contain a Recordset object, so it is important to avoid confusion.
<LI>Bracket query parameters ([Forms]![frmSomething]![txtStart] instead of Forms!frmSomething![txtStart])
<LI>Modify code for formatted MsgBox (using @ in the prompt text doesn't work any more)
<LI>Recent versions of Access have more restrictions on when a query based on more than one table is updatable. Make sure that there is a unique index on the "one" side of a join.
<LI>Merging data to a Word document has changed drastically in Office 2002.
<LI>The use of Unicode causes some characters to be displayed differently.[/list]As with all versions, Access 2003 has bugs. Many bugs that existed in the original release have been fixed in the recently issued Service Pack 1, but no doubt there are others.