Ms access 2010

[lilelvis2000]

We have been upgrading to 2007, rather than 2010. The menu system is different. In older versions you could build a menu by hand and then manipulate it via VBA. For some reason that's all been changed. Although they will work, adding extra functionality is a bit of a pain in tha arse as you can no longer easily add/remove/modify items or check the code they run. We have a database that I inherited and the developer built amenu system from hell. Rather than rebuild it completely (because I don't fully understand the database) I added extra items in the immediate window. Anything I build from the ground up I use a table to hold all the menu items and VBA to process it, so adding items to groups is pretty easy.

MS say that you can use XML to generate menus, but I looked into it but it's a complete nightmare to work with!

Yeah you end up using a third-party tool - like this one to do it for you. I haven't tried it myself, but will give it a go on my next project.

[BoredBloke]

We have been upgrading to 2007, rather than 2010. The menu system is different. In older versions you could build a menu by hand and then manipulate it via VBA. For some reason that's all been changed. Although they will work, adding extra functionality is a bit of a pain in tha arse as you can no longer easily add/remove/modify items or check the code they run. We have a database that I inherited and the developer built amenu system from hell. Rather than rebuild it completely (because I don't fully understand the database) I added extra items in the immediate window. Anything I build from the ground up I use a table to hold all the menu items and VBA to process it, so adding items to groups is pretty easy.

MS say that you can use XML to generate menus, but I looked into it but it's a complete nightmare to work with!

[Jaws]

Recently done some work with SSRS on SQL Server 2008. IIS is no longer a requirement, it's all fairly easy to set up if you are using standard windows authentication. We just ran the setup & installed SSRS in integrated mode.

Once the URLs are configured via the configuration tool, a Report Manager website is set up. This is where you can upload the reports you create using visual studio, business intelligence studio or the report builder tool that is available on the report manager website.

Configuring it to work over the internet with forms authentication was a bit of a pain in the backside however.

[eek]

Quick thread hijack...

I've used SSIS loads and I'm just starting to look at SSRS. If I write a report, how do I actually run it in anger?

You need a proper version of Sql server and IIS on the same machine. Beginning SQL Server 2005 Reporting Services Part 1 is the first google search that seems to give a reasonable explanation of the steps.

Its a software house, they are not interested in the right thing to do, just the most profitable

its a bit sad really. but as a contractor - I just have to suck it up

As its a software house its still an option. You just need to convince the end client its worth the extra £x,000 or that they'll be able to sell it to other clients.

[EternalOptimist]

Want to learn SQL server, SRSS and c#? It looks like the perfect time to suggest a rewrite to a modern n-tier custom solution with the ability to have reports sat in their inbox first thing every morning.

Its a software house, they are not interested in the right thing to do, just the most profitable

its a bit sad really. but as a contractor - I just have to suck it up

[Lockhouse]

Want to learn SQL server, SRSS and c#? It looks like the perfect time to suggest a rewrite to a modern n-tier custom solution with the ability to have reports sat in their inbox first thing every morning.

Quick thread hijack...

I've used SSIS loads and I'm just starting to look at SSRS. If I write a report, how do I actually run it in anger?

[eek]

forms are all built in code

we dont need ado

but the original dev was a custom menu fiend from hell


kerchinnnnggggg - rewrite

Want to learn SQL server, SRSS and c#? It looks like the perfect time to suggest a rewrite to a modern n-tier custom solution with the ability to have reports sat in their inbox first thing every morning.

[EternalOptimist]

I haven't had any issues with DAO as its the default in 2010 anyway. You can untick the ADO library if it gets added in and you're not using it.

Only other issue is that the forms layout can get messed up sometimes but it usually pretty easy to sort out.

Then you have deal with the whole new Ribbon. and if you had a custom menu and toolbar before, they get ignored. I haven't been able yet to figure out how to customise that.

Other than that, easy peasy.

forms are all built in code

we dont need ado

but the original dev was a custom menu fiend from hell


kerchinnnnggggg - rewrite

[lilelvis2000]

I haven't had any issues with DAO as its the default in 2010 anyway. You can untick the ADO library if it gets added in and you're not using it.

Only other issue is that the forms layout can get messed up sometimes but it usually pretty easy to sort out.

Then you have deal with the whole new Ribbon. and if you had a custom menu and toolbar before, they get ignored. I haven't been able yet to figure out how to customise that.

Other than that, easy peasy.

[EternalOptimist]

The security model has changed and things that were implied in 2003 now need to be explicitly stated.

The big one from memory is that you need to explicitly reference the DAO object model.

Apart from that its the slog of going through that vba code and trying to get it to compile.

dao.recordset type of thing ?


they are using mde rather than the security model

[eek]

Have been asked to do some work in 2010.

this includes a migration from 2003


Does anyone know of any issues with 2010
or

migration issues.

the migration is reasonably high level stuff, no queries or macros, 90%VBA




TIA

The security model has changed and things that were implied in 2003 now need to be explicitly stated.

The big one from memory is that you need to explicitly reference the DAO object model.

Apart from that its the slog of going through that vba code and trying to get it to compile.

[EternalOptimist]

Have been asked to do some work in 2010.

this includes a migration from 2003


Does anyone know of any issues with 2010
or

migration issues.

the migration is reasonably high level stuff, no queries or macros, 90%VBA




TIA