On Thursday April 26 2007 7:27 pm, Mohd Afifuddin Bin Omar wrote:
> Thanks for the support,
>
> My requirement is to open MAccess database file mdb by using oO
> Base and use it as if the file in MAaccess and continue fill the
> data without doing any editing, all those forms, reports, and it's
> queries. I can't imagine to redo it again in oO Base in order to
> continue using the MAccess mdb file like getting the report or
> finding my data.
>
> I would appreciate to use it just like you open the Excel file
> *.xls in oO Calc and immediately use it to continue your work or
> amend anything in it.
>
> Regards.
Sorry, but that is not how databases work. The database begins
with data listed in fields which are then grouped in tables. How
these tables are placed in forms depends upon the engine used by the
particular database type. MS Access uses one method of creating the
forms, and OOo used another method. If you want to access MS Access
files with all of the forms and reports, you have to use the MS
Access engine, namely the MS Access program.
Dan
> > -----Original Message-----
> > From: news [SMTP:[EMAIL PROTECTED] On Behalf Of NoOp
> > Sent: Friday, April 27, 2007 4:18 AM
> > To: [email protected]
> > Subject: [users] Re: Database
> >
> > On 04/25/2007 11:45 PM, Mohd Afifuddin Bin Omar wrote:
> > > Thanks for the advise, but I was thinking it work just like
> > > words/write or Excel/Spreadsheet. Any comment?
> >
> > As Kirill said:
> > >> File - New - Database - Connect to existing database -
> > >> Microsoft Acees - browse to your .mdb file - Finish.
> >
> > You cannot open a .mdb file in Word or Excel, nor can you open
> > one in Writer or Calc.
> >
> > Once you've opened the MDB file, you can then select any of the
> > tables, right click & open. You can then edit any of the data
> > just as you would in MS Access. To move the data to a Calc sheet,
> > or Writer doc, simply right click on the table, select copy, then
> > past into Calc or Writer.
> >
> > If you have linux, I highly recommend installing MDB Viewer:
> > http://mdbtools.sourceforge.net/
> > It's about 1000 times faster and will also show what reports,
> > forms & macros are in the database (you can't export or view
> > those as you can the tables) - you can then export the tables to
> > a proper csv and then open w/Calc, Writer, Base etc., and the
> > _all fonts_ will even be correct in the resulting csv.
> >
> > >> -----Original Message----- From: Kirill S. Palagin
> > >> [SMTP:[EMAIL PROTECTED] Sent: Thursday, April 26, 2007 2:15
> > >> PM To: [email protected] Subject: RE: [users] Database
> > >>
> > >> File - New - Database - Connect to existing database -
> > >> Microsoft Acees - browse to your .mdb file - Finish.
> >
> > -----------------------------------------------------------------
> >---- To unsubscribe, e-mail: [EMAIL PROTECTED] For
> > additional commands, e-mail: [EMAIL PROTECTED]
>
> -------------------------------------------------------------------
>-- To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
