update from 2000 to 2003 TimPGrace 25.09.2006 16:41:02 My company is getting ready to upgrade from Access 2000 to Access 2003. We have run into problems in the past from 2.0 to '95, 95 to '97, and to a lesser degree '97 to 2000. We have many different access databases in use, for many different purposes. Before we install the updated version, I need to find out if there are any potential problems we might encounter with the code or data formats. Most (not all) of the databases are using back-end tables, with a separate design front-end. Some are using ODBC linked tables (to SAP, ORACLE) and some link to Excel files. Most (not all) are using Access' security with workgroups. Thanks

Re: update from 2000 to 2003 "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 25.09.2006 21:49:00 The default file format for Access 2003 (and 2002, for that matter) is the Access 2000 file format, so realistically you shouldn't need to do anything. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "TimPGrace" <TimPGrace[ at ]discussions.microsoft.com> wrote in message news:E547EF05-B450-458D-AD17-CF663BDD0B70[ at ]microsoft.com... [Quoted Text] > My company is getting ready to upgrade from Access 2000 to Access 2003. > We > have run into problems in the past from 2.0 to '95, 95 to '97, and to a > lesser degree '97 to 2000. We have many different access databases in > use, > for many different purposes. Before we install the updated version, I > need > to find out if there are any potential problems we might encounter with > the > code or data formats. > > Most (not all) of the databases are using back-end tables, with a separate > design front-end. Some are using ODBC linked tables (to SAP, ORACLE) and > some link to Excel files. Most (not all) are using Access' security with > workgroups. > > Thanks

RE: update from 2000 to 2003 Jerry Whittle 26.09.2006 15:08:02 STOP! Did that make you panic just a little? ;-) Due to a Patent dispute, you cannot change, add, or delete data in tables that are linked to an Excel workbook in Office Access 2003 or in Access 2002! http://support.microsoft.com/kb/904953 http://www.theregister.co.uk/2006/02/07/microsoft_office_access_infringement/ -- Jerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "TimPGrace" wrote: [Quoted Text] > My company is getting ready to upgrade from Access 2000 to Access 2003. We > have run into problems in the past from 2.0 to '95, 95 to '97, and to a > lesser degree '97 to 2000. We have many different access databases in use, > for many different purposes. Before we install the updated version, I need > to find out if there are any potential problems we might encounter with the > code or data formats. > > Most (not all) of the databases are using back-end tables, with a separate > design front-end. Some are using ODBC linked tables (to SAP, ORACLE) and > some link to Excel files. Most (not all) are using Access' security with > workgroups. > > Thanks

Re: update from 2000 to 2003 "Ragnar Midtskogen" <ragnar_ng[ at ]newsgroups.com> 26.09.2006 20:02:31 I can think of one little annoyance: In some cases, when you open a form based on a query as Access starts up, you get a dialog that says 'Not a valid bookmark'. I believe this is a bug that can be fixed by editing an item in The Registry. I have done this a couple of times but now I can't remember which item. I fixed it by running a batch file that I downloaded, but now I can't find out how to download the file either. I didn't pay too much attention because I Googled 'not a valid bookmark' and it was one of the first hits. Now I can't find it, maybe someone else in this group has run into this? Ragnar