Converting MS ACCESS 2000 mdb to 2007 mdb

[AirDuster101]

Hi,

We will be installing MS ACCESS 2007 in the near future. I have some MS
ACCESS 2000 MDBs. Should I convert them to MS ACCESS 2003 first or I can
convert them to MS ACCESS 2007 directly? Is there any known problem between
version 2000 and version 2007?

Thanks

AD

 

[dbahooker]

yeah MDB sucks every version

move to Access Data Projects and SQL Server

that way you can reuse your existing DATABASE when you rewrite it in a
real language

I highly reccomend ADP for all people

 

[Allen Browne]

There is no point at all converting them to Access 2003.

Access 2000 can use the A2000 MDB files even without converting them. You
can modify tables, edit data, create queries/forms/report, write code etc.
Some things are a little to get used to (e.g. if you defined custom
toolbars), but it all works without conversion.

Of course, you might *want* to convert them to A2007 so you can use some of
the new stuff.

More info:
Converting to Access 2007
at:
http://allenbrowne.com/Access2007.html

 

[AirDuster101]

Thank you.

There is no point at all converting them to Access 2003.

Access 2000 can use the A2000 MDB files even without converting them. You
can modify tables, edit data, create queries/forms/report, write code etc.
Some things are a little to get used to (e.g. if you defined custom
toolbars), but it all works without conversion.

Of course, you might *want* to convert them to A2007 so you can use some of
the new stuff.

More info:
Converting to Access 2007
at:
http://allenbrowne.com/Access2007.html