Downgrading Access03 to97

[Roman]

I am currently using Office2003 Suite.
So the database Access was automatically converted from 97Access to
03Access.
Is there anyway to reverse to 97Access format?
The reason is that the third computer is loaded with 97Office Suite.
In order to use Access with the third computer, the access format must be
converted into 97 format.
Roman

 

['69 Camaro]

Hi, Roman.

So the database Access was automatically converted from 97Access to
03Access.
Is there anyway to reverse to 97Access format?

Select the Tools -> Database Utilities -> Convert Database -> To Access 97
file format... menu. After conversion, you'll probably need to open it in
Access 97 and fix the library references from Office 11.0 versions to Office
8.0 versions. Don't forget to compile the VBA code afterwards.

Next time you open the Access 97 database in Access 2003, select the "Enable
database" choice, not the "Convert database" choice. Conversion is not
required. And if the multiuser database were designed as a split database,
the Access 97 computer would have its own copy of the front end and each of
the other Access 2003 computers would have their own copies of the front
end, so there wouldn't be any "stepping on toes" with the wrong versions.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Roman]

Thank you Gunny,

Roman

Hi, Roman.


Select the Tools -> Database Utilities -> Convert Database -> To Access 97
file format... menu. After conversion, you'll probably need to open it in
Access 97 and fix the library references from Office 11.0 versions to
Office 8.0 versions. Don't forget to compile the VBA code afterwards.

Next time you open the Access 97 database in Access 2003, select the
"Enable database" choice, not the "Convert database" choice. Conversion
is not required. And if the multiuser database were designed as a split
database, the Access 97 computer would have its own copy of the front end
and each of the other Access 2003 computers would have their own copies of
the front end, so there wouldn't be any "stepping on toes" with the wrong
versions.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

['69 Camaro]

Thank you Gunny,

You're welcome. Glad to help.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[GIRL94]

hei ciao a tutti!soprattutto ai maski!