Upgrading to Access 2000

FAQs About Upgrading to Access 2000

When I convert an Access database to Access 2000, can I open it in a previous version of Access?

Do macros in my previous-version database work in Access 2000?

Does code in my previous-version database work in Access 2000?

What is ADO?

Can I disable the dialog box that prompts me to choose between converting and enabling a database?

Can I convert a replica set?

Can I convert a secured database?

What are data access pages?

What is an Access project?

When I convert an Access database to Access 2000, can I open it in a previous version of Access?

You cannot open an Access 2000 database in a previous version of Microsoft Access. However, you can convert an Access 2000 database to Access 97 file format.

Top

Do macros in my previous-version database work in Access 2000?

In most cases, macros in previous-version databases work in Microsoft Access 2000.

Top

Does code in my previous-version database work in Access 2000?

In most cases, code in previous-version databases works in Microsoft Access 2000. However, in some cases, you might have to update your code. For example, you must update code when it contains 16-bit API calls, or when it contains older versions of DAO objects, methods, and properties that depend on the DAO 2.5/3.x compatibility library.

Top

What is ADO?

ActiveX Data Objects (ADO) are programming objects that represent the structure of your database and the data that it contains. In Visual Basic Editor, you can use ADO objects and an additional component of ADO called Microsoft ADO Extensions for DDL and Security (ADOX) to create or change tables and queries, secure your database, or access data from external data sources. You can also use ADO objects in code to manipulate data stored in your database. ADO and ADOX support access to any data source that has an ODBC driver or OLE DB provider created for that data source. This includes Access databases (MDB files) through the OLE DB Provider for Microsoft Jet 4.0, and SQL Server 6.5 and 7.0 databases through the Microsoft OLE DB Provider for SQL Server.

The Microsoft DAO 3.6 Object Library is also available in Microsoft Access 2000. A converted Access database contains a reference to this library.

Top

Can I disable the dialog box that prompts me to choose between converting and enabling a database?

You cannot disable the dialog box that prompts you to choose between converting and enabling a database.

Top

Can I convert a replica set?

You can convert a replica set to Access 2000, but you must convert each replica individually. For more information, see How to Convert a Previous-version Database to Access 2000.

Top

Can I convert a secured database?

You can convert or enable a secured database as long as you use the information in the original workgroup information file to maintain security. If you cannot recreate the workgroup information file in Access 2000, it is recommended that you convert it. For more information, see How to Convert a Previous-version Database to Access 2000.

Top

What are data access pages?

Data access pages are Web pages that you can use to add, edit, view, or manipulate current data in a Microsoft Access database or an SQL Server database. You can create pages that are used to enter and edit data, similar to Access forms. You can also create pages that display records grouped hierarchically, similar to Access reports.

Top

What is an Access project?

A Microsoft Access project (ADP file) is a new type of Access file that provides efficient, native-mode access to a Microsoft SQL Server database through the OLE DB component architecture. Using an Access project, you can easily create a client/server application. Working with a Microsoft Access project is very similar to working with an Access database. The process of creating forms, reports, data access pages, macros, and modules is the same. When you connect to an SQL Server database, you can view, create, modify, and delete tables, views, stored procedures, and database diagrams by using the Microsoft SQL Server Design Tools.

Top

See also

For more information about new features in Microsoft Access 2000, see Microsoft Access online Help.