access 97 to 2000

[Antz]

2000 MS Office installed
and need old 97 QM database converted to Access 2K,
can i have my 2000 Office Access users still open the Office 97 DB's?
Or should i convert it to 2000?

please make sure there is a 97 backup before conversion.

 

[Beth Melton]

The Access 97 database converted in order to open it in Access 2000.

If you open it in Access 2000 then you should be prompted to convert
to the Access 2000 file type.

Also, you'll need to make sure there is a backup - I can't do that for
you. ;-) Although you will be asked to create a new database so the
old one should be preserved. Provided, of course, you use a different
file name and/or location.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

 

[Antz]

great thanks

The Access 97 database converted in order to open it in Access 2000.

If you open it in Access 2000 then you should be prompted to convert
to the Access 2000 file type.

Also, you'll need to make sure there is a backup - I can't do that for
you. ;-) Although you will be asked to create a new database so the
old one should be preserved. Provided, of course, you use a different
file name and/or location.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

 

[Don MI]

Beth, if I recall correctly the backup is automatic as the conversion does
not change the original file. I recall that after the conversion was
completed and I tried to save the converted file I received an error message
unless I changed the file name or folder. I do not recall the exact wording
of the error message, but it was a hard error not just a warning that I was
over writing an existing file. Or, perhaps my recall is wrong.

Don

 

[Beth Melton]

Just gotta make me verify this for sure, don't you Don? <g>

Looks like your memory is correct. If you use the same file name and
location in the "Convert Database Into" dialog box you'll encounter
"Can not replace existing file as a result of converting the Microsoft
Access database. You must select a new file name".

I wasn't 100% certain you'd be prompted so I threw in the "different
file name/location" just to be safe. ;-)

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

 

[Don MI]

At my age I can never be sure about memory. <g>

Don