Jim DeMarco
Jdemarco at hudsonhealthplan.org
Wed May 3 13:59:28 CDT 2006
Funny. I had a similar experience with A2K when it first came out and was also expecting nightmare problems this time but all is well so far. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of rusty.hammond at cpiqpc.com Sent: Wednesday, May 03, 2006 10:08 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Converting Access 97 to Access 2003 Thanks Jim, that's good news. It seems like when I played with converting apps to Access 2000 some years ago, there were some immediately noticeable things that we were going to have to fix after the conversion. Thanks again, Rusty -----Original Message----- From: Jim DeMarco [mailto:Jdemarco at hudsonhealthplan.org] Sent: Wednesday, May 03, 2006 7:55 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Converting Access 97 to Access 2003 Rusty, We're in the midst converting many Access 97 apps to 2003 and have encountered nothing to stop us thus far. The apps range from tiny workgroup level tools with mdb FE and BE to larger sytems with SQL BE's. HTH, Jim DeMarco -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of rusty.hammond at cpiqpc.com Sent: Tuesday, May 02, 2006 6:22 PM To: accessd at databaseadvisors.com Subject: [AccessD] Converting Access 97 to Access 2003 I'm just starting to work on converting our Access 97 databases over to Access 2003 and the first one I tried converted with no issues and seems to work fine so far. I still have lot of testing to do but I can hardly believe I haven't found issues yet. This is a fairly involved application (front end utilizing SQL 2000 linked tables, importing excel spreadsheets, exporting to excel and running code in the excel workbook, etc..) I ran the Access 2003 Conversion toolkit and the details of the database are: 111 Tables 186 Queries 65 Forms 52 Reports 12 Macros (for custom menu bar) 12 Modules (with thousands of lines of code). My question is, has everyone that has done this type of conversion had this same type of success with converting to A2003? Rusty Hammond IT Dept. - B-20 CPI Qualified Plan Consultants, Inc. (620) 793-8473 ext. 416 rusty.hammond at cpiqpc.com ********************************************************************** WARNING: All e-mail sent to and from this address will be received, scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc. corporate e-mail system and is subject to archival, monitoring or review by, and/or disclosure to, someone other than the recipient. ********************************************************************** -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ********************************************************************** WARNING: All e-mail sent to and from this address will be received, scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc. corporate e-mail system and is subject to archival, monitoring or review by, and/or disclosure to, someone other than the recipient. ********************************************************************** -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com