Change from Access 2003 to 2010

[Gkirkup]

I have a large application written in Access 2003, running on a server, split database. We are migrating to Access 2010 on the server. Are there issues in updating to Access 2010? Will anything in Access 2003 no longer work, or require modification?

Robert

 

[StarGrabber]

Let me see if I understand your scenario right. You migrate to the 2010 version on the server but not on the clients? - And, in general, why do you use Access on a server instead of a SQL Server backend (or MySQL or DBASE or Oracle or...)?? How many users connect to the backend?

However, as long as you don't change the backend file format from .mdb to .accdb everything should work.

 

[cpberg1]

We recently did the upgrade but just to 2007. Not sure how much of my experience will apply to you.

We needed to edit trust center settings on each users machine for the path of the FE.

Added VBA to setup custom ribbon for MDE/ACCDE users.

Also many text boxes that were just big enough to display a full Date/Time ended up just a hair smaller (or font slightly bigger) resulting in ####### until expanded slightly in design mode.

Additionally we were using a custom calendar for date time fields and 2007 has built in that works so removed a bunch of those custom calendar widgets.

Pretty minor in my experience.

 

[StarGrabber]

Thank you cpberg1 for advising the issue with the trust center.

How did you get a textbox to display a value like "#######"? I know this from Excel. But Access?

There is no need to add VBA for custom ribbons. Menu bars from Access 2003 can be used in the 2010 version as well.

 

[Gkirkup]

Thanks cpberg1. That is helpful. I do use a calendar widget, and as long as it still works probably will not change it. I was looking for anything in 2003 that will not work in 2010, but I doubt if that will be a problem.

Robert

 

[Gkirkup]

I don't understand the issue of the trust center. What does that mean?

Robert

 

[cpberg1]

I don't understand the issue of the trust center. What does that mean?

Robert

If you use much VBA in the database you'll need to add trusted locations. More info here. Can't get hyperlink to operate properly, posting from my IPad. Copy/pâté to browser sorry. Or google it.


http://office.microsoft.com/en-us/a...settings-in-the-trust-center-HA010354326.aspx

 

[cpberg1]

How did you get a textbox to display a value like "#######"? I know this from Excel. But Access?

You'll see it right away in form view if it affects you. It just happened automatically if the field is too small to display all the data. Worked fine on day 1/1/2013 (only 8 characters) but was obvious on 01/26/2013 (10 characters). Just widen the textbox slightly in design view.

 

[cpberg1]

Thanks cpberg1. That is helpful. I do use a calendar widget, and as long as it still works probably will not change it. I was looking for anything in 2003 that will not work in 2010, but I doubt if that will be a problem.

Robert

The issue is that the new calendar widget automatically displayed next to the textbox when you place the cursor in a textbox with record source with datatype date/time. It covered up (partially) our custom control so when you clicked it sometimes you would get the new style and sometimes the old, plus it looked bad. Perhaps you can turn off the new automatic calendar widget display when in the text boxes, I didn't go looking for that setting. Otherwise the functionallity of the old calendar widget was intact.

Best,