RE: Conversion 411

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

You should just need to compact the backend. The frontend should not have
any data tables.

"Pattyt" wrote:

> Thanks for your info.
>
> When I do compact and repair do I do it on both the FE and BE?
>
> "Robert1105" wrote:
>
> > 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.
> >
> > "Pattyt" wrote:
> >
> > > 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
.

Quantcast