[AccessD] Upgrading to Access 2002 from A2K

Mark Whittinghill mwhittinghill at symphonyinfo.com
Wed May 7 15:29:30 CDT 2003


I already use late binding for that very reason.  Thanks for the link.  I'll check it out.

Mark Whittinghill
Symphony Information Services
612-333-1311
mwhittinghill at symphonyinfo.com
  ----- Original Message ----- 
  From: MartyConnelly 
  To: accessd at databaseadvisors.com 
  Sent: Wednesday, May 07, 2003 1:11 PM
  Subject: Re: [AccessD] Upgrading to Access 2002 from A2K


    You will have problems with Ole Automation and references to Excel Word Outlook if they are used, but by sacrificing a bit of speed you can use late binding to default to to the installed version of Word etc rather than using Word 9 or Word 10 libraries.
     Also make sure your clients are all using the same version of  Jet, I believe A2K came with  Jet SP3.  You can get Jet SP6 from here which may ameliorate your odd crashes. get the correct version for the OS. Before you install SP6  on a computer that is running Windows 95, Windows 98, or Windows NT 4.0, you must already have Jet 4.0 Service Pack 3 (SP3) or later installed. You have at least Jet 4.0 (SP3) if the file msjet40.dll is version 4.00.2927.4 or later

  http://support.microsoft.com/default.aspx?scid=kb;en-us;Q282010

  Mark Whittinghill wrote:

That was my plan, to set default to A2K.  I didn't know that about the
decompiling.  If I build an app in AXP/A2K default then distribute it to A2K
users, will there be any troubles with references or anything?

Mark Whittinghill
Symphony Information Services
612-333-1311
mwhittinghill at symphonyinfo.com
----- Original Message -----
From: "Dan Waters" <dwaters at usinternet.com>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, May 07, 2003 11:29 AM
Subject: RE: [AccessD] Upgrading to Access 2002 from A2K


  
Mark,

There is a recognized bug in AXP that prevents decompiling an mdb.
    
However,
  
if you set the mdb format to A2K when you develop in AXP, you will still
    
be
  
able to decompile.  You can choose A2K to be the Default File Format in
Tools | Options - Advanced before creating a new database.

Other than that, I am pretty satisfied with AXP.  I've had an occasional
crash, but nothing I would consider a problem.  I am, however, an avid
control-s guy!

Dan Waters
Quality Process Solutions


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark
    
Whittinghill
  
Sent: Wednesday, May 07, 2003 11:51 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Upgrading to Access 2002 from A2K


Hi all,

  Recently my computer died due to power source failure, though I was able
to recover files later.  I was due to upgrade my computer here anyway, so
    
I
  
now have a new computer with Windows XP, the old one was Windows 2000.  We
have yet to do any work in Access 2002.  Some of our clients use that, but
we just send Access 2000 versions.

  I never used to have problems with Access 2000, though I have read many
posts from people who had.  Now that I have Windows XP,  I am having
    
crashes
  
all the time, with the "Send Error Report"  dialog box.  Twice in the last
couple weeks I have had things get corrupted so bad that I just had to
restore my file from an earlier version and flush my work for the day down
the toilet.  Based on what I am hearing of Access 2002, I am thinking that
    
I
  
should just upgrade to that, even though I work in 2000 file format.  Are
there any downsides to doing that?  Thanks for any advice.

Mark Whittinghill
Symphony Information Services
612-333-1311
mwhittinghill at symphonyinfo.com

_______________________________________________
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


    

_______________________________________________
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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030507/f21e8796/attachment-0001.html>


More information about the AccessD mailing list