de-secure and convert Access 97 to 2003

[mbox204]

As a brief overview, the following in admitted as a general method for
converting a secured Access DB. Without providing the lengthy exact
details, am I in the right direction?

1.. De-secure the Access 97 backend and perform any table specific design
changes.
2.. Export the 12 database backend table objects into a neutral Access 97
database, one that references a neutral System.mdw file, bring copy of file
in case....
3.. Compile the de-secured Access 97 back-end database.
4.. Temporarily install a full version of Access onto the main computer
that will be hosing the database back-end.
5.. Perform the actual conversion of Access 97 backend to Access 2003 file
format.
6.. Uninstall the full version of Access 2003 from the database host
computer
7.. Perform actual application front-end / back-end installation using the
new Runtime version of Access, install program generated by package
deployment wizard .
8.. On completion of the front-end file installation, copy the newly
converted Access 2003 back-end from step 5 into the application data folder
area.
9.. Complete application install by linking front-end to new back-end
using the custom built menu features in the front-end.

 

[david epsom dot com dot au]

1) Although it is a good idea to create a new workgroup
for the new version, it is not necessary.

2) For design changes, you need design permissions.
If your distribution workgroup does not include a
development user, you need a workgroup that does.

3) There is no need to 'compile' a backend database.
Compilation is what you do to VBA code. Your backend
database should not, and probably does not, have any
VBA.

4) You don't need Access to do a database conversion:
You don't need Access on the server to do an Access
conversion (you can do the conversion anywhere): You
don't need to do an Access Conversion to do a database
conversion. You don't need Retail Access to do an
Access or Database conversion (just database permissions)

Copy the backend files to any PC that has Access installed
to do a full Access conversion, or use Access to convert
them in place across the network, or use VB Script to do
just a database conversion using DAO or JRO CompactDatabase,
either in place or on any PC that has DAO or JRO installed.

10. You haven't scripted re-securing your database if
you de-secured in step 1

(david)