[AccessD] Upgrading from Access 2000 to 2003

Kath:
>>>>>>>There is a new level of error checking in 2003. Any controls that do
not have tne control source in a form's source will create new error
messages (shouldn't have any of those but it found a couple!) . Error
checking levels can be adjusted thru the menu. (tools, options, error
checking).
>>>>>>>
Is this why I get, in A2k2-3, random #error in text boxes that have
"=GetDefault()" or some such function call as their source?  I have been
just moving these function calls to the code in form.current, and that has
worked around it.  Lowering, or turning off one these options in Error
Checking will prevent this?

Thanks,
Steve



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kath Pelletti
Sent: Monday, November 27, 2006 8:36 PM
To: Access D Normal List
Subject: [AccessD] Upgrading from Access 2000 to 2003

I've been keeping track of issues I have faced when I had to upgrade a
client's system from Access 2000 to 2003 this month. 

I thought it might be worthwhile posting my brief list in case anyone else
needs to do the same - and maybe those of you who have worked in 2003 more
than I have can add to it.....

- Start with new 2003 database, and change default file format to 2002-2003
before importing all objects, file import specs, relationships.
- Recreate Startup options and update all references
- Check all report settings for reports which do not use the default
printer. (I found that those that use a specific printer, eg. pdf995 had
reverted to default printer on import).
- Check that toolbars are displayed. Even though they are imported, I found
that I had to turn then on manually (change properties to allow them to be
turned on / turn them on / change properties back again)
- All references to the commondialog control need to be re-written (browse /
save dialogues)
- Change the [Tools] [Macro] [Security] level to Low to prevent users
getting the msg "Do you want to block unsafe expressions?"
- There is a new level of error checking in 2003. Any controls that do not
have tne control source in a form's source will create new error messages
(shouldn't have any of those but it found a couple!) . Error checking levels
can be adjusted thru the menu. (tools, options, error checking).

______________________________________
Kath Pelletti
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com