Difference between revisions of "Talk:MSA-Base Faq"

From Apache OpenOffice Wiki
Jump to: navigation, search
 
(11 intermediate revisions by 3 users not shown)
Line 1: Line 1:
I edited vLookup to Dlookup. AFAIK Access does not have a vLookup function. If vLookup was intended and correct, pls change it back.
+
== How do I import/convert my Access database to Base ==
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.
 
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.
Line 36: Line 17:
 
Dale
 
Dale
  
 +
== Lookup Columns ==
  
Later: this is already addressed on the FAQ(Base) page. I suppose the question now is where does it best belong?
+
Edited to bring it up to its own main topic and specifically state that it refers to table design.--[[User:Dale|Dale]] 14:05, 2 October 2006 (CEST)
 
+
quote
+
 
+
=== Can I use Microsoft Access databases (.mdb) in Base? ===
+
  
On Windows: yes. You cannot open them directly via <code>File|Open</code>, but you can access the data therein. For this, you need the [http://msdn.microsoft.com/data/ref/mdac/downloads 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.)
+
== How do I use Domain Aggregate functions in Base? ==
  
Then, go to <code>File|New|Database</code>, 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!
+
Added entry. Pls review for correctness, and clarity. Add any further explanation that seems appropriate.--[[User:Dale|Dale]] 14:07, 2 October 2006 (CEST)
  
== Is a Form in Base different from a Form in MSA? ==
+
== How do I add Calculated Controls to my forms and reports? ==
  
quote
+
Added entry. This is almost a direct copy of DrewJensen's contributions in oooforum.org. Pls review to make sure I haven't trashed Drew's good words.--[[User:Dale|Dale]] 14:08, 2 October 2006 (CEST)
  
Is a Form in Base different from a Form in MSA?
+
== Workarounds for limitations ==
No.
+
  
There are very real differnces between how Forms are implemented in Access and Base.  
+
Is this the appropiate place to collect limitations and possible workarounds? Searching the forums etc. is sometimes hard due problem description etc.
 +
When question is yes, how do we do it? Short description with link to topic on form or adding solution as well?
 +
Any thoughts?
 +
Erik
  
/quote
+
== Change the title of this page ==
  
I might be missing something, but shouldn't this be "Yes. There are ..."
+
As a newbie I had some problems migrating from Access. The title of the page is *not* helpful. You have to know that MSA means "Microsoft Access". You can't find it when searching by title. The title should be something like "Migrating from Microsoft Access". Can someone change it for me. I'm scared I might mess it up. [[User:Tenbob|Tenbob]] 01:58, 22 December 2009 (UTC)

Latest revision as of 01:58, 22 December 2009

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

Lookup Columns

Edited to bring it up to its own main topic and specifically state that it refers to table design.--Dale 14:05, 2 October 2006 (CEST)

How do I use Domain Aggregate functions in Base?

Added entry. Pls review for correctness, and clarity. Add any further explanation that seems appropriate.--Dale 14:07, 2 October 2006 (CEST)

How do I add Calculated Controls to my forms and reports?

Added entry. This is almost a direct copy of DrewJensen's contributions in oooforum.org. Pls review to make sure I haven't trashed Drew's good words.--Dale 14:08, 2 October 2006 (CEST)

Workarounds for limitations

Is this the appropiate place to collect limitations and possible workarounds? Searching the forums etc. is sometimes hard due problem description etc. When question is yes, how do we do it? Short description with link to topic on form or adding solution as well? Any thoughts? Erik

Change the title of this page

As a newbie I had some problems migrating from Access. The title of the page is *not* helpful. You have to know that MSA means "Microsoft Access". You can't find it when searching by title. The title should be something like "Migrating from Microsoft Access". Can someone change it for me. I'm scared I might mess it up. Tenbob 01:58, 22 December 2009 (UTC)

Personal tools