update from 2000 to 2003

[TimPGrace]

My company is getting ready to upgrade from Access 2000 to Access 2003. We
have run into problems in the past from 2.0 to '95, 95 to '97, and to a
lesser degree '97 to 2000. We have many different access databases in use,
for many different purposes. Before we install the updated version, I need
to find out if there are any potential problems we might encounter with the
code or data formats.

Most (not all) of the databases are using back-end tables, with a separate
design front-end. Some are using ODBC linked tables (to SAP, ORACLE) and
some link to Excel files. Most (not all) are using Access' security with
workgroups.

Thanks

 

[Douglas J. Steele]

The default file format for Access 2003 (and 2002, for that matter) is the
Access 2000 file format, so realistically you shouldn't need to do anything.

 

[Jerry Whittle]

STOP! Did that make you panic just a little? ;-)

Due to a Patent dispute, you cannot change, add, or delete data in tables
that are linked to an Excel workbook in Office Access 2003 or in Access 2002!

http://support.microsoft.com/kb/904953

http://www.theregister.co.uk/2006/02/07/microsoft_office_access_infringement/

 

[Ragnar Midtskogen]

I can think of one little annoyance: In some cases, when you open a form
based on a query as Access starts up, you get a dialog that says 'Not a
valid bookmark'.
I believe this is a bug that can be fixed by editing an item in The
Registry. I have done this a couple of times but now I can't remember which
item. I fixed it by running a batch file that I downloaded, but now I can't
find out how to download the file either. I didn't pay too much attention
because I Googled 'not a valid bookmark' and it was one of the first hits.
Now I can't find it, maybe someone else in this group has run into this?

Ragnar