Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

(Access 2000 File Format)

Status
Not open for further replies.

AlexCuse

Programmer
Apr 13, 2006
5,416
US
Is there an easy way to update a file created in Access 2000 to Access 2003? Or simply get the above message to disappear?

The app was mostly written in 2003, but I started it when I was still on 2000. Of course I ignored the wizart that asked me if I wanted to upgrade it to 2003...

I delivered finished product yesterday, and keep getting asked 'Why does it say (Access 2000 File Format)'. I would like to put an end to this annoyance if possible ;)

Ignorance of certain subjects is a great part of wisdom
 
Try Options->Advanced->Default File Format

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill
 
Yeah, I've tried that. I guess its' only for new files, because it does not ask me if I want to convert or anything when I reopen :-(

Ignorance of certain subjects is a great part of wisdom
 
Ah, it was Tools --> Database Utilities --> Convert

Why did I think it was in options??

Ignorance of certain subjects is a great part of wisdom
 
I've just always kept it in the 2000 format - I've never found a reason to have it in 2003 format. A couple of reasons I use the 2000 format:

#1. File can still be used by both Access2000 and Access2003 installs
#2. That's the default format Access2003 uses when you create a new database - and I can't help but think that there's a reason (maybe Microsoft knows something I don't - or maybe it's just because of reason #1 again)


 
My mistake. [blush]

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill
 
Yeah I ended up switching back. She would've just asked 'Why does it say Access 2002-2003 file format' if I had gone with the change. I don't see any advantage to going to 2003 format, so I'm sticking with 2000.

Greg - your suggestion is to change what to do for new databases. How could you mix those two up ;-)

Thanks for taking the time to read

Alex

Ignorance of certain subjects is a great part of wisdom
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top