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.
ImImInAsked:
Who is Participating?
 
Jeffrey CoachmanMIS LiasonCommented:
Unfortunately, the only thing you will be able to bring into Access is the raw table data.

(Make a backup of the entire Approach database system first.)

TABLES
The best way would be to export all the tables to the Excel format. (or the CSV format)
You may still have to tweak the data types if they don't end up being exactly what they wee in Approach.
See here for info on Access data types:
https://support.office.com/en-in/article/Introduction-to-data-types-and-field-properties-30ad644f-946c-442e-8bd2-be067361987c

FORMS and REPORTS
Then you must rebuild your Forms and Reports from scratch.
Fortunately, Access has a great set of wizards to hep you with this.

QUERIES
If Approach uses SQL as a query engine, then "theoretically" you should be able to copy the SQL and paste it in the Access SQL query designer in Access, then simply save it as a query.

SEARCH
As far as a "Search", ...my guess is that you mean "Filtering"
In the most basic sense, ..you can create a form in Access (for example, ...based on the Customer table), ...then create a combobox (again, using the combobox wizard), ...then select the "Find a record on my form" option.
This will allow you to select a customer from the list, ...then display (filer for) that customer's record only.
Filtering can also mean something like filtering all Customers that live in "China" (Text)", or all Employees with a Department ID of 7 (Number).
his will require (VBA) programming, ...(outside the scope of this basic explanation.)
...But the syntax will be different for text and Numbers:
For example:
me.Filter="Country=" & "'" & USA & "'"
Me.Filter="DepartmentID=" & 7

This should give you a solid starting point for your conversion.
;-)

JeffCoachman
0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
From scratch, I'm afraid. The data can be exported to 1-2-3, then to Excel, then imported into Access.

See this thread for more information.

Sorry.
0
 
Richard DanekeTrainerCommented:
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.
0
 
Jeffrey CoachmanMIS LiasonCommented:
glad I could help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.