ImImIn
asked on
Changing over from Lotus Approach v3 to MS Access
I need some advice on changing over from Lotus Approach v3 to MS Access. I need to know what is involved on making the data transfer from Lotus to Access and is the easiest way to set up all of the user interfaces (how Approach displays the data and allows you to search and set that up in Access) up in Access? Is there some kind of software or conversion tools available or will things have to be set up from scratch?
Thank you for your help.
Thank you for your help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It really depends on your version of Access. ODBC drivers for dbase files will let you open the Lotus Approach databases. You can then, copy the data into new Access tables using queries in Access.
As far as the rest - yes, you will need to recreate the forms and reports. At least you can have tabbed operations now in Access similar to the Approach user interface.
Technically, you could keep the data as linked tables in Access, but I would NOT recommend it.
As far as the rest - yes, you will need to recreate the forms and reports. At least you can have tabbed operations now in Access similar to the Approach user interface.
Technically, you could keep the data as linked tables in Access, but I would NOT recommend it.
glad I could help.
See this thread for more information.
Sorry.