logo.GIF (4199 bytes)

Software solutions that give your data a high powered tune-up.

DataLeverage

Home
Up
Company
Our Mission
Software Tools
Automation
Product Snapshots
Access Training
VB Training
Web
Testimonial
Contact

Microsoft Access 2000 Upgrade

tinylogo.gif (2557 bytes)

For further information (617)739-9925 or e-mail at info@dataleverage.com

  1. How do I start the Access 2000 Upgrade?
  2. Why doesn't my Access 2000 program work?
  3. What if I need an item from a previous version?
  4. Can I convert to an older version: Access 97, Access 95 and Access 2.0?
  5. Are there advantages to Access 2000?
  6. When is the best time to convert?

How do I start the upgrade to Access 2000?

In order to convert to Access 2000,  select: Tool, Data Utilities, Convert Database.  The program will now upgrade.  If the original versions only has tables, queries, reports and forms, usually all will be converted successfully.  However, if the new version is not working correctly or missing items, you might have to manually do the conversion.  Start by create a blank Access 2000 database.  From the new database select: File, Get external data, Import and Select an items to import.  Repeat the previous process until all items are imported.   If a module is imported and not working properly see: Why doesn't my Access 2000 program work?
Back to Top

Why doesn't my Access 2000 program work?

Access 2000 modules changed the mechanism for accessing data using Visual Basic.  Previous version used Data Access Object (DAO).  The default interface for new database created in Access 2000 is ActiveX Data Objects (ADO).  If a converted module does not work make sure that DAO 3.6 is the selected object library.  From an Access module select : Tools, References, Microsoft ActiveX Data Objects 3.6 Library.  
Back to Top

Can I convert to Access 97 from Access 2000?

For the first time Access allows user to convert to a previous version.  This is especially useful when you need to share information in an earlier version. Select: Tools, Database Utilities, Convert Database, To Prior Access Database Version. Only modules can be converted to an earlier version if the module were written in Data Access Object (DAO).

Back to Top

What if I need an item from an earlier version?

In order to get information from an Access database in an earlier version simply click on: Files: Get External Data, and Import.  If tables, queries, report or forms are import, usually all will be converted successfully.  If a module is imported see: Why doesn't my Access 2000 program work?

 

Back to Top

Are there advantages to Access 2000?

Access 2000 has many new features.  A few of the new features are listed below.

Under Queries, Union are now supported.  This allows users to  join two mailing list with a union statement.  In forms, fields can now be displayed vertically.  

Repair and Compact can now is now processed in one step.  

Access 2000's new Name Autocorrect feature allow user to change table names and have the changes automatically be made to queries, forms, reports and macros.  The ensure that this property is set select : Tools, Options, General and check everything under Name Autocorrect.

 

Back to Top

When is the best time to Upgrade?

Access 2000 offers many new features.  You must upgrade your Access 97, Access 95 and Access 2  database to Access 2000 to use these features.  However,  If you are not making major changes to your database you can continue to use Access 97 or older version even if you are using Office 2000.  However, if  your database contains only Microsoft Access Tables, Microsoft Access Queries, Microsoft Access Report or Microsoft Access Forms there should be not problem with upgrading.  

Back to Top

iconsm.GIF (195 bytes) Application Programming iconsm.GIF (195 bytes) Database Consulting iconsm.GIF (195 bytes) Web Development iconsm.GIF (195 bytes) Training
iconsm.GIF (195 bytes) SQL Server iconsm.GIF (195 bytes) Visual FoxPro iconsm.GIF (195 bytes) MS Access iconsm.GIF (195 bytes) Visual Basic

tinylogo.gif (2557 bytes)
For further information call (617)739-9925 or e-mail at 

Copyright 2000  DataLeverage. All rights reserved.
Revised: July 09, 2003 .

 


For further information call:  (617)739-9925 
Copyright 2000  DataLeverage.  All rights reserved.