 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Conversion / August 2005Conversion 411
Hello, I currently have a couple of databases in 2000 format that are split into BE/FE and that have user-level security. Our IS department is in the process of upgrading our office suit from 2002 to 2003. I read that it is not necessary to convert my 2000 db's to 2003 because 2003 will read 2000 formats. However if I do opt to convert my databases, what is the process to follow and do I have to compact and repair? As you can see I am fairly new to this and I would like to get as much info. as possible. Thank You First, if you have not recently conducted a compact and repair, I would do it right away. Corruption can creep into your DB slowly before it become critical. I have not migrate to Access 2003; however, I share your ideas that your SW should migrate quite seamlessly. I would first do a back-up of your FE and BE. Then do a compact and repair and test the results. If the results are OK, I would back-up this version of the data. Having created and safely stored a back-up I would open your FE and link you BE in Access 2003. IT will most likely ask you if you would like to upgrade, I would select yes as you have a back-up of the previous version just in case this does not work. I would then test the new environment and do a compact and repair. Finally, I would make a new back-up of the data after this compact and repair. (Did I get you making too many back-up's? I figure I can always delete redundant data with the simple press of a button. Recreating this data would take many, many more button presses.) Good Luck. > Hello, > I currently have a couple of databases in 2000 format that are split into [quoted text clipped - 8 lines] > > Thank You Thanks for your info. When I do compact and repair do I do it on both the FE and BE? > First, if you have not recently conducted a compact and repair, I would do it > right away. Corruption can creep into your DB slowly before it become [quoted text clipped - 35 lines] > > > > Thank You You should just need to compact the backend. The frontend should not have any data tables. > Thanks for your info. > [quoted text clipped - 39 lines] > > > > > > Thank You > Thanks for your info. > [quoted text clipped - 39 lines] > > > > > > Thank You |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.