By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,968 Members | 1,295 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,968 IT Pros & Developers. It's quick & easy.

Compatibility

P: n/a
Is it possible to use a database developed in Office 97, and upgraded to
Office XP on a machine running Office 2000
TIA
Stephen
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
AccessXP defaults to Access2000 format. As long as you didn't change that
and you did not use anything new in AccessXP not in Access2000 your database
will run using Access2000.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!
"Stephen Doyle" <st***@dmsystems.co.nz> wrote in message
news:1131835701.499349@ftpsrv1...
Is it possible to use a database developed in Office 97, and upgraded to
Office XP on a machine running Office 2000
TIA
Stephen

Nov 13 '05 #2

P: n/a
G'day Stephen,

There are two possible glitches, the database file format and the VBA
compilation inside the file.

Access 97 created an Access 97 database file.

Office XP / Access 2002 can do two things with the Access 97 file. It
can either mark it for data editing etc... and keep it as an Access 97
file (in which case, Access 2002 cannot change the design of the forms
and reports etc...) or it can convert it to Access 2000 format or Access
2002 format.

If it has been converted to Access 2000 format, then Office 2000 /
Access 2000 can edit the data and change the designs within it. So can
Office XP/Access 2002.

However, if you do any programming in Access 2002 and then open the file
in Access 2000, you will probably hit the VBA compilation problem -
although the data in the file is compatible between Access 2002 and
Access 2000, I have found that the programming stops working.

Try to keep all your Access versions the same - this isn't something
like Word Processing where Word 97, 2000, 2002, 2003 have tried to be as
compatible as possible in the document.

Ananda

Stephen Doyle wrote:
Is it possible to use a database developed in Office 97, and upgraded to
Office XP on a machine running Office 2000
TIA
Stephen

Nov 13 '05 #3

P: n/a

"PC Datasheet" <no****@nospam.spam> schreef in bericht news:FM***************@newsread2.news.atl.earthlin k.net...
If you can't get the help you need in the newsgroup, I can help you for a
very reasonable fee. Over 1000 Access users have come to me for help.
These 1000 (if at all a real figure..) is only the result of
-- 4 years abusing the newsgroups.
-- 4 years blatantly advertising and job hunting.

You only care about making money, and you act as if the groups are your private hunting ground.
So why would ANYBODY ever trust a person like you and hire you?
************************************************** ******
Need a month calendar or 7 day calendar? Need appointment scheduling? Need
room reservations scheduling? Need employee work scheduling? Contact me!


Need a psychiatrist ...Contact me!

Arno R

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.