Upgrading a Project from 2000 to 2003

[Guest]

My company recently upgraded my computer from MS Access 2000 to 2003. I get
a message when I open up old projects asking if I'm sure I really want to
open this file as it may be corrupt.

How do I convert the 2000 project to 2003 format so that I can avoid this
message and enjoy the functionality of the new version.

Thanks

David

 

[Douglas J. Steele]

Are you sure that's the message you're getting (that it may be corrupt), or
is it "This file may not be safe if it contains code that was intended to
harm your computer"?

The latter is a new "feature" of Access 2003.

 

[Guest]

You are right. That is the message that is displayed.

I know that the file is good I would just like to update it.

Thanks

 

[Douglas J. Steele]

You'll get that message regardless of what format the database is in.

Take a look at
http://home.bendbroadband.com/conradsystems/accessjunkie/macrosecurity.html
for some suggestions on how to turn the message off.

 

[Guest]

Thank you. That is good to know that there is not something that is going to
crap out my system. Can I update/upgrade/convert from 2000 to 2003 though?

Or should I leave it as it is and use it or rewrite it??

Thanks

 

[Douglas J. Steele]

There was a long discussion about this exact point recently, and no real
conclusion was reached.

Access 2003 actually uses the Access 2000 format by default. Many people
leave it in that format, simply to maximize the number of potential clients
that can use the database.

One reason to convert is if you're going to want to use an MDE, rather than
an MDB. Access 2003 can only create an MDE if the file is in Access 2003
format.

While aimed at Access 2002, I believe the following article applies to
Access 2003 as well:

http://msdn.microsoft.com/library/en-us/dnacc2k2/html/odc_acFormat.asp