Conversion to Access 2003 from 2000

[Guest]

I have a multi-user db written in Access 2000 but all systems have been
upgraded to Access 2003. I have made some updates to the system in my
development area and am ready to release them into the "live" system. When
I go to make the new .mde, it tells me that I cannot do that without
converting the database to 2003. Now that is the easy part to explain and
I'll explain a little about the database.

I have a frontend file that people access the system through. I am not
Access expert but the .mde file is in this area. Then there are the backend
files where the data is stored. There are quite a few of these backend files
where data is located and archived.

Now comes the question. Can I convert the front-end file that I use to make
the .mde file from 2000 to 2003 (then create new MDE) and leave the remaining
backend files in the old format? If this is possible, can I backup the 2000
db and then convert the database into the new 2003 format and rename the new
converted one the same as the old db with no change to anyone's access?
Hopefully that made sense. People access the system by running a .bat file
that opens the front end.

I can provide more info if needed.

Thanks

 

[Van T. Dinh]

1. You certainly can leave the BE as it is. Access 2000, 2002 and 2003 use
the same JET 4 engine.

2. There should not be any problems, in general, convert a FE from A2000
file format to A2002-A2003 file format (Access 2002 and Access 2003 use the
same file format).

Keep backups as an insurance but I have not had any problem converting from
A2002 file format to A2002-A2003 file format. The steps you described
sounds fine to me.

 

[Guest]

Thanks. I am not Access expert and maintain a system that was built in the
past. When a change is needed, I get to learn new things. The only problem
that I have ran into when testing this in my development area is that I am
not getting a mde to be created. I follow the steps but it hangs up. I
don't recall how long it should take to make an mde, but I let it wait quite
a while last time and now response.

Todd

 

[Van T. Dinh]

Try converting the MDB file to A2002-A2003 format then use Access 2003
software to make the MDE from the converted MDB.

Make sure you recompile the code after converting to A2002-A2003 file format
to pick up all compilation errors and check the References ... before trying
to make MDE.