| Chat with a LIVE Microsoft
Access Expert! |
||||
|
|
|||
|
||||
|
||||
|
#1
09-01-2007, 07:49 AM
|
|||
|
|||
|
Office 2000 to Office 2003
My office is upgrading from office 2000 to 2003 this weekend. Should I run the
"Tools - Database Utilities - Convert Database - To Access 2002 2003 Format" I have about 10 small databases various users access. Is it good practice to run this or just keep it in an office 200 format? Thanks. 
|
| Sponsored Links |
|
#2
09-01-2007, 08:26 AM
|
||||
|
||||
|
AFAIK there is no need to convert your db's to the 2002/2003 format unless you make changes and are creating MDE's.
__________________
(RG for short) aka Allan Bunch MS Access MVP  acXP, ac07 - WinXP Pro, Win7Please post back to this Forum so all may benefit. Teaching is not filling a bucket but lighting a fire.
|
|
#4
09-01-2007, 08:45 AM
|
||||
|
||||
|
When you make an MDE out of an MDB, Access strips out all of the source code and makes it very difficult for the user to do other than what you intended. It is sort of a psudo exe but you still need Access to run the code. If you are not doing that then I would not worry about it at this time.
__________________
(RG for short) aka Allan Bunch MS Access MVP acXP, ac07 - WinXP Pro, Win7Please post back to this Forum so all may benefit. Teaching is not filling a bucket but lighting a fire.
|
|
#5
09-01-2007, 08:51 AM
|
|||
|
|||
|
O I see... I will not be making any MDEs anytime soon so that is of no use to me.
So there is no need for me to convert all of my databases then. Just keep using them as I always have. Anytime they are opened it will just say (Access 2000 file format) at the top and that is no big deal? Thank you for the help so far. Travis
|
|
#6
09-01-2007, 08:54 AM
|
||||
|
||||
|
Quote:
__________________
(RG for short) aka Allan Bunch MS Access MVP acXP, ac07 - WinXP Pro, Win7Please post back to this Forum so all may benefit. Teaching is not filling a bucket but lighting a fire.
|
|
#7
09-01-2007, 09:02 AM
|
||||
|
||||
|
Quote:
__________________
(RG for short) aka Allan Bunch MS Access MVP acXP, ac07 - WinXP Pro, Win7Please post back to this Forum so all may benefit. Teaching is not filling a bucket but lighting a fire.
|
|
#8
09-01-2007, 09:18 AM
|
|||
|
|||
|
"normalized" is not a term I am familiar with. I am all self taught so it might be, but I just might know what it is called.
I will try to leave everything as is, try a couple changes with it in the Access 2000 format and see what happens. THANK YOU for all of your help today.
|
|
#9
09-01-2007, 09:26 AM
|
||||
|
||||
|
Just search this forum for "Normalizaion" to learn more about this and why its a good thing.
__________________
The best solution is the simplest one that meets all requirements. How to get your questions answered promply
|
| Sponsored Links |
 |
| Thread Tools | |
| Display Modes | Rate This Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Problem with MS Access 2000 application on Windows Server 2003 | MauriceM | General | 2 | 03-04-2008 05:46 AM |
| Win 2000 and Office 2000 to Win XP and Office 2003 | Haynesey | Reports | 0 | 09-21-2005 03:33 AM |
| Access 2003 to 2000 bug | Skeletal | General | 12 | 03-19-2005 11:16 AM |
| Can Access 2003 users cause corruption in an Acess 2000 DB? | NJudson | General | 3 | 01-27-2005 06:09 AM |
| Access 2003 on Office 2000 woes | ksaab | General | 5 | 08-02-2004 05:53 AM |
Linear Mode
