From: mynamehere@comcast.net   
      
   "Ian Barnes"  wrote in message   
   news:d9aabt$d7r$1@nwrdmz03.dmz.ncs.ea.ibs-infra.bt.com...   
   >I have a VB6 program that uses standard ADO 2.5 connection to read and write   
   to   
   >an Access 97 database on a Windows 98 machine. The same program is run by a   
   >number of other people who use Windows 98 or 2000 machines. They all connect   
   to   
   >a their local copy of the DB with no problems. Occasionally, this database is   
   >opened in Access 97 (we all currently use 97) in order to make some manual   
   >tweaks here and there.   
   >   
   > But ,I am about to get a new XP machine with Access 2003.   
   >   
   > Q1. Will my VB6 program still work?   
   > Q2. Will I be able to open the DB in Access 2003 without upsetting my VB   
   > program?   
   > Q3. Assuming that Q1 and Q2 are not a problem, can I easily ship the compiled   
   > application the uses described above, bearing in mind that their OS and   
   lesser   
   > version of Access? I assume that they won't be able to load the database in   
   > Access 97 after I've been forced to convert it to 2003, but will the VB   
   > application work using the standard ADO 2.5 connection?   
   >   
      
   In this territory, there are always some "excepts" and "gotchas", but I think   
   this is a correct summary:   
      
   1. If you convert the data file to Access 2000 or later format, your VB app as   
   is will not run. You will need to recompile it, using ADO 2.8, meaning the   
   later   
   VB service packs and later versions of MDAC. The file will no longer be   
   readable   
   by Access 97.   
      
   2. If you don't convert the file, you can "enable" it for use with Access 2003.   
   This will allow you to edit data in it using Access 2003, but you will not be   
   able to modify table structures - no adding fields or indexes, modifying field   
   definitions, or creating or editing relationships.   
      
   Pick your poison.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)