Access 2000/2003

[Malcolm Webb]

My database was developed and is currently running in Access 2000.

I am contemplating upgrading to the latest version of Access (2003?)
running on new computers.

Will there be any major problems running a 2000 db in 2003?

My only reason for upgrading is because the MS Office 2000 Professional
disks got lost in our office move, otherwise I would install 2000 onto the
new machines.

Alternatively, does any kind soul have a copy of MS 2000 Office
Professional which they no longer need and would be prepared to sell?

Malcolm Webb
Lincoln UK

[Allen Browne]

You should have a painless experience, moving from A2000 to 2003.

You will need to set Tools | Macro | Security to Low to avoid a series of
annoying messages where Microsoft tries to convince you not to open your
database, *every* time you try to open it.

If you used references such as the Calendar control or MS Graph, you might
have to fix your references after conversion:
http://allenbrowne.com/ser-38.html

If you find that forms with a subform begin crashing, see point 3 under the
Development section in this article:
http://allenbrowne.com/ser-25.html

A2003 can be more pedantic about the way you refer to controls on a subform.
If this becomes an issue, be sure to include the ".Form" bit explained here:
http://allenbrowne.com/casu-04.html

Be sure to install at least SP1 for Office 2003. SP2 also includes some
important fixes, but breaks your ability to write to an existing Excel
spreadsheet if you need that.

Beyond that, you should have no issues that you did not already have in
A2000.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Malcolm Webb" <mf********@yah oo.co.uk> wrote in message
news:me******** *************** *@mfwebb.compul ink.co.uk...

My database was developed and is currently running in Access 2000.

I am contemplating upgrading to the latest version of Access (2003?)
running on new computers.

Will there be any major problems running a 2000 db in 2003?

My only reason for upgrading is because the MS Office 2000 Professional
disks got lost in our office move, otherwise I would install 2000 onto the
new machines.

Alternatively, does any kind soul have a copy of MS 2000 Office
Professional which they no longer need and would be prepared to sell?

Malcolm Webb
Lincoln UK

[Malcolm Webb]

>You should have a painless experience, moving from A2000 to 2003.

That's good to know :-)

Be sure to install at least SP1 for Office 2003. SP2 also includes some
important fixes, but breaks your ability to write to an existing Excel
spreadsheet if you need that.

Oh dear! :-(

I have half a dozen fairly complicated documents created in Excel. Data
from my database is pasted into specific cells in the documents so that I
can print them off or send them by e-mail.

These forms are used to pass information to Social Services (we are a
domiciliary care service). The forms were originally blanks provided by
Social Services with the intention of us filling them in by hand and
faxing them. Most other similar companies do just that.

I have recreated them in excel and all the required information is pasted
into specific cells. Apart from one field needing a date, there is no
manual input into these forms.

I will go back to my original plan of acquiring a copy of MS Office 2000
Professional and continue using my existing version.

Many thanks for all the help and advice.

Malcolm Webb

[Allen Browne]

Ouch.

So you can read more about it, Microsoft's blurb on this change:
You cannot change, add, or delete data in tables that are linked
to an Excel workbook in Office Access 2003 or in Access 2002
at:
http://support.microsoft.com/kb/904953/en-us

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Malcolm Webb" <mf********@yah oo.co.uk> wrote in message
news:me******** *************** *@mfwebb.compul ink.co.uk...

You should have a painless experience, moving from A2000 to 2003.

That's good to know :-)

Be sure to install at least SP1 for Office 2003. SP2 also includes some
important fixes, but breaks your ability to write to an existing Excel
spreadsheet if you need that.

Oh dear! :-(

I have half a dozen fairly complicated documents created in Excel. Data
from my database is pasted into specific cells in the documents so that I
can print them off or send them by e-mail.

These forms are used to pass information to Social Services (we are a
domiciliary care service). The forms were originally blanks provided by
Social Services with the intention of us filling them in by hand and
faxing them. Most other similar companies do just that.

I have recreated them in excel and all the required information is pasted
into specific cells. Apart from one field needing a date, there is no
manual input into these forms.

I will go back to my original plan of acquiring a copy of MS Office 2000
Professional and continue using my existing version.

Many thanks for all the help and advice.

Malcolm Webb