>From the Microsoft Access 2000 help file:
Convert an Access 2000 database to Access 97
Open the Microsoft Access database that you want to convert. If it is a multiuser
database that is located on a server or in a shared folder, make sure that no one else
has it open.
Important If you have protected the Microsoft Visual Basic for Applications (VBA)
code, you must supply the password before you convert the Access database. To supply
the password, start Microsoft Visual Basic by opening a module; then click
databasename Properties on the Tools menu and enter the password in the databasename
Password dialog box..
If you are converting a secured Access database, you must have Open/Run and Open
Exclusive permissions for the database itself, and Read Design permissions for all
objects in the database. To secure the converted database, you must open it in
Microsoft Access 97 and apply user-level security..
On the Tools menu, point to Database Utilities, click Convert Database, and then click
To Prior Access Database Version.
In the Convert Database Into dialog box, type the name of the new previous-version
database that you want to create in the File name box, and then click Save.
Note If your Access 2000 database contains code, you may need to fix missing
references after you have converted it to Microsoft Access 97. Also, if your Access
database uses add-ins or library databases that were created in Access 2000, you must
convert them back to Access 97 as well.
--------
About converting an Access 2000 database to Access 97
You can convert a Microsoft Access 2000 database to an Access 97 database if it is not
a member of a replica set. Any functionality that is specific to Access 2000 is lost
when you convert the database to Access 97.
Converting an Access 2000 database to an Access 97 database makes the following
changes to the converted database.
Links to data access pages are lost.
Data that relies on Unicode support in Access 2000 might not be converted correctly.
Access 97 uses characters from only a single code page � a numbered set of 256
characters. For example, an Access 97 database might use only ANSI characters. During
conversion, the collating order of the original Access 2000 database determines which
set of characters the resulting Access 97 database can use; any characters that are
not in this set are not converted correctly.
An Access 2000 database containing a table with a FieldSize property of Decimal cannot
be converted to Access 97. You must change the FieldSize property to another value
such as Single or Double, or you must change the field's data type to Currency before
you can successfully convert the database.
If you are converting a secured Access database, the user account that you use to log
on must have the following permissions:
Open/Run and Open Exclusive permissions for the database itself. Read Design
permissions for all objects in the database.
To secure the converted database, you must open it in Microsoft Access 97 and apply
user-level security.
If you have protected the Access database with a password, you can convert it without
removing the password. If you have protected the Microsoft Visual Basic for
Applications (VBA) code with a password, you must supply the password in the Visual
Basic Environment.
Monday, January 22, 2001, John wrote:
JA> Here! Here!
JA> It would take some serious armtwisting and a little money stuffed in my
JA> pocket to get me to upgrade from Access 97. It would have been so much
JA> simpler if MS had allowed a "Save As Access 97" in Access 2000.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
