Talk:MSA-Base Faq

I edited vLookup to Dlookup. AFAIK Access does not have a vLookup function. If vLookup was intended and correct, pls change it back. Dale.

Can Base read my Access database

We seem to be missing a couple of obvious FAQs. Probably because the page has just started and they no one has got around to them yet.

Can Base read/write/open my Access database? As of version 2.0: Tables - yes. Need some instruction (sorry - I'm completely ignorant of how to do this) Queries - no (was there something about table views for Access queries?) Forms - no. Reports - no. Macros - no. Modules - no.

+ + + + + Dale.

How do I import/convert my Access database to Base

We seem to be missing a couple of obvious FAQs. Probably because the page has just started and no one has got around to them yet.

How do I import/convert my Access database to Base?

As of ver 2.0 there is no direct method for this. Tables can be read from the mdb or converted to a more Base-friendly format (native Base tables, Calc spreadsheet, csv). <<Probably need some indication of method here. Or maybe reference to a separate (yet to be written) HowTo>>

Forms and reports cannot be imported and have to be re created from scratch.

There is no direct equivalent to Access macros. These have to be re created from scratch in a language supported by OOo (StarBasic, ...)

Code modules: OOo and Base do not support VBA. The code used in you Access database will have to be rewritten in a language supported by OOo.

+ + + + + Dale