Upgrading a Access 2000 application to Access 2003

K

Kayleen

Can someone give me some guidance on how to upgrade an Access 2000
Application to Access 2003. My application has the following pieces: FE(MDE)
BE(MDB) WG(MDW) plus a GV.mde that is called via code. I have access to all
the code except the GV.mde, of couse the database will not open without this
file. I would like to upgrade to a SQL server backend but maintain the
Access FE.

Thanks,
Kayleen
 
J

John Vinson

Can someone give me some guidance on how to upgrade an Access 2000
Application to Access 2003. My application has the following pieces: FE(MDE)
BE(MDB) WG(MDW) plus a GV.mde that is called via code. I have access to all
the code except the GV.mde, of couse the database will not open without this
file. I would like to upgrade to a SQL server backend but maintain the
Access FE.

Thanks,
Kayleen
Click to expand...

Going from 2000 to 2003 is dead easy: just open the database using
2003. Actually, Access2003 defaults to using the 2000 database format.

The only "gotcha" is that you must use Tools... Database Utilities...
Convert Database to convert the .mdb file to 2003 format before it
will let you make a new mde file.

Converting to a SQL/Server backend is rather more of a chore. If you
have bound forms, you may find that performance gets worse not better,
and you will need to change the way you think about database
maintenance! You might want to get a copy of Mary Chipman and Andy
Baron's book "Microsoft Access Developer's Guide to SQL Server" (SAMS)
or consult the chapters in the Access <version> Developer's Handbook
by Getz et al. (Sybex) if you have that useful tome.


John W. Vinson[MVP]
 
K

Kayleen

Thank you John for responding so quickly. I have an addition question. Will
I need to convert all the 2000 .mdb to 2003 for this database to run? Can
access 2003 run using a 2000 format .mde? I only have a .mde for one of the
databases and was not provided the original .mdb so I cannot access the code
for this program and the database will not run without this database. Does
2003 support the Access workgroup security mdw files?

Thanks,

Kayleen
 
J

John Vinson

Thank you John for responding so quickly. I have an addition question. Will
I need to convert all the 2000 .mdb to 2003 for this database to run?
Click to expand...

No. Access2003 not only can *run* A2000 format databases; if you
create a new database in A2003, it creates it in A2000 format unless
you specifically direct otherwise.
Can access 2003 run using a 2000 format .mde?
Yes.

I only have a .mde for one of the
databases and was not provided the original .mdb so I cannot access the code
for this program and the database will not run without this database. Does
2003 support the Access workgroup security mdw files?
Click to expand...

Yes - and they can be any format from A97 on.

John W. Vinson[MVP]
 
Top