MS Access 2003 to 2010

**Easto** · 12-31-10, 01:09 AM

I know there are a billion sites telling me what to look out for but...

The last 7 years I've been dinking around with Access 2003. If I upsize to 2010 what kind of headaches should I expect?

**YARDofSTUF** · 12-31-10, 06:40 AM

You get a new menu system at the very least.

**CableDude** · 12-31-10, 08:08 AM

upsize?

**Easto** · 12-31-10, 10:48 AM

Originally Posted by CableDude

upsize?

Had a few drinks in me and couldn't think of the correct term.

**Shinobi** · 12-31-10, 11:42 AM

The "ribbon"

and also, you can publish direct to sharepoint sites.

http://office.microsoft.com/en-us/ac...010342117.aspx

This also will help you from 2003 to 2010 (.PDF file / guide):
http://officeimg.vo.msecnd.net/en-us...F101980365.pdf

Everyone loves "Migration"

**Easto** · 12-31-10, 02:24 PM

Thanks Shinobi, that was exactly what I was looking for.

I now have to read up on the sharepoint info. I can program and design an Access database but have no idea how to move it to the web etc etc. I guess I've got some reading ahead.

**CableDude** · 12-31-10, 03:11 PM

Originally Posted by Shinobi

Everyone loves "Migration"

**Shinobi** · 12-31-10, 05:03 PM

Originally Posted by Easto

Thanks Shinobi, that was exactly what I was looking for.

I now have to read up on the sharepoint info. I can program and design an Access database but have no idea how to move it to the web etc etc. I guess I've got some reading ahead.

Not too hard at all.. You'll see.. just need to know the sharepoint address / UNC and then "publish". If your good with Access databases and are good with share point you got a good skill set for many IT jobs. What do you do currently for IT work?

**Easto** · 12-31-10, 05:12 PM

Years ago I created an Access application that we used in 2 of our offices. I work for a freight forwarder and the app tracked shipments from pickup to delivery and everything inbetween. Our company used it for about 3 years. Then they decided to move to an inhouse internet app and since then I've just made small little apps that people in the office ask for. To answer your question... I'm not in IT, I'm in Operations. The database work has just been a hobby/diversion.

**Shinobi** · 12-31-10, 08:22 PM

Originally Posted by Easto

To answer your question... I'm not in IT, I'm in Operations. The database work has just been a hobby/diversion.

Time to switch careers.

**Easto** · 12-31-10, 09:43 PM

That would be nice.

At this point what I'm trying to do is design a database and an extremely powerful but user friendly front end (at this point I'm only working on the tables and relationships).

At work I've been exposed to several different expensive programs that do the same thing but each one seems to miss the mark. They either take it to a level where you have to almost be a progammer to understand and/or take a couple of months to learn. I guess part of what I'm doing is no different than what anyone else would do, take the best ideas and blend them into something I could be proud of and... sell, or at least market myself as a developer.

Fortunately it's not my first line of income so I'm able to work on it when the mood strikes me and there's no pressure to finish.