Payserv wrote:
I have a large payroll/human resource application written in Microsoft
Access.
I would like to know what is involved in converting to openoffice.
Do I have to rewrite all that VBA code?
Yes - there is some VBA support in OO.o coming soon ( already here in
some distributions ) but it is targeted to Word and Excel files, Access
is not available.
Will my 230 reports convert ?
No - you will have to recreate these.
A couple of quick comments: you will find the Base using the embedded
database engine will not scale as well as MS Access ( understatement )
and is not multi-user. So, if you want to convert I would recommend
looking at using one of the FOSS database managers ( PostgreSQL as an
example ) for the backend. Base can handle the front end work ( Forms,
Querys, Reports ). For the reporting needs don't even try wit the Report
Wizard and instead grab the SUN Report Builder extension.
Finally
- the users mailing list for the Base project is quite active and for
this project I would strongly recommend make use of it. The archives are
available at http://dba.openoffice.org/servlets/ProjectMailingListList
- You will also find a number of documents dealing with MS Access issues
on the wiki at
http://wiki.services.openoffice.org/wiki/Database
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
