Home
Up
Company
Our Mission
Software Tools
Automation
Product Snapshots
Access Training
VB Training
Web
Testimonial
Contact
| |
- How do I start the Access
2000 Upgrade?
- Why doesn't my Access 2000 program work?
- What if I need an item from a previous version?
- Can I convert to an older
version: Access 97, Access 95 and Access 2.0?
- Are there advantages to Access 2000?
- When is the best time to convert?
|
|
|
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? |
|
|
|
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. |
|
|
|
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).
|
|
|
|
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?
|
|
|
|
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.
|
|
|
|
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.
|
 |
Application
Programming |
|
Database
Consulting |
|
Web
Development |
|
Training |
|
SQL Server |
|
Visual
FoxPro |
|
MS
Access |
|
Visual
Basic |
For further information call
(617)739-9925 or e-mail at
Copyright © 2000 DataLeverage. All rights reserved.
Revised: July 09, 2003
.
|
