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.

Later: this is already addressed on the FAQ(Base) page. I suppose the question now is where does it best belong?

quote

Can I use Microsoft Access databases (.mdb) in Base?

On Windows: yes. You cannot open them directly via File|Open, but you can access the data therein. For this, you need the Microsoft Data Access Components, which are available from Microsoft for free. (In Windows XP, they're already included, so you need them for older Windows versions only.)

Then, go to File|New|Database, choose "Connect to an existing datbase", and select the "Microsoft Access" database type from the list. On the next page, you then select the .mdb file you want to access - that's it!

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