Alternative to Office Automation Via VBA MS Access 1

[1DMF]

Hi,

If we wanted to ditch MS Access because of the cost of having to by Office Professional just to get it, what would be the way to do this?

shoudl we get Visual Studio and convert the MS Access DB over to a full blown visual basic application, and then we would only require the basic version of office for word / excel & outlook?

Or is it possible to go .NET and turn everything web based?

But then how would I create XLS spreadsheets, or utilise mailmerges in Word?

Is it worth trying to ditch MS Access or is the boss just being tight?

If we moved away from MS Access, they'd still have to train me in the new platform / language and provide the environment, so is it worth the move.

Is it worth it just to get training in .NET or full VB ?

Cheers,
1DMF

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[dhookom]

Why not use your Access version of the Run-Time?

Duane
Hook'D on Access
MS Access MVP

 

[1DMF]

Thanks Duanne,

I was actually just coming back to post, as I have had my reseller confirm, with Office 2007+ you can compile your MS Apps with a runtime and distibute them that way.

All I need now is a new PC, MSO 2007+ and some training


"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts