Convert Lotus Approach to MS Access

[Cletus Robinson]

I have just been asked by a prospect to quote on
converting several databases from Lotus Approach 97 to MS
Access 2002. While I know I can inmport the data easily,
what about the views that exst in Approach? Is there
some "magic bullet" to bring those over?

Thanx for your time!

 

[Tony Toews]

I have just been asked by a prospect to quote on
converting several databases from Lotus Approach 97 to MS
Access 2002. While I know I can inmport the data easily,
what about the views that exst in Approach? Is there
some "magic bullet" to bring those over?

Not that I've ever seen.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[John Nurick]

Hi Cletus,

I've never heard of a magic bullet for this: you'll need to re-create
all the functionality using Access's tools (and if the Approach views
are defined in SQL this can be pasted into Access and edited for the new
names and differences in syntax).