Hmm. Connection to an existing database is what you want, but it sounds
as if the Access file is password protected, so you'd need that to open
it and see the tables. You won't be able to view or copy in the tables
until you have at least read access to the mdb file. But did it ever ask
for a password, or just say it was invalid? If the latter, you'd have to
be able to get an unprotected version of the file before Base can get at
it. Or maybe the file was corrupted somehow, I don't know if Base would
assume an unreadable file was encrypted. In either case, I think you'll
have to get the mdb file again. Since the other user you mentioned was
able to get at the mdb file in OOo, maybe he can copy in the tables and
send you an odb file with them already there?
Thanks for the pointers, NoOp, I'm going to read that material myself.
I've brought in several Access databases, but always just to capture the
tables and recreate my queries and reports in Base.
Mark Knecht wrote:
Barbara,
Thanks for the response. I don't need any forms from Access. Mostly
I'm just looking to poke around in the database itself so I can see
what's there. I don't have a copy of Access but heard from another
user that Access is used in this app. I also heard from him that he's
opened the database with Open Office so it should be doable.
However, when I try opening the database I first start Base and
then choose the file called NDTSMain.mdb. Base acts like it's OK with
the file but then what I get is Writer showing a bunch of gibberish.
Maybe I'm doing this completely wrong. Does the database file have
to be imported into OO before Base can access it? If I ask base to
connect to an existing database (instead of open an existing database)
it does see the file so that's good. This pops up a databse GUI of
some sort. I can click on Queries, Forms or Reports and I don't have
problems. (I don't see anything, but I don't have problems.) When I
click on Tables it complains that it cannot connect, invalid password.
Thanks,
Mark
On Thu, Sep 18, 2008 at 8:25 AM, Barbara Duprey <[EMAIL PROTECTED]> wrote:
Mark Knecht wrote:
Is any part of Open Office able to read/modify files that are used in
a Windows app based around Access?
I can supply a simple file if it's a matter of testing. I've never
messed with database programs so I know nothing about this.
Thanks,
Mark
The database component, Base, can be connected to Access tables, which can
be used in place or copied into Base's HSQLdb engine. But the other parts of
the Access database (forms, queries, reports) and anything like programs or
scripts built for custom processing, are not available to Base. It uses a
completely different structure. It has the capabilities to create or support
analogous items, though, so it depends on how complex the Access database
and other things are to determine whether this is feasible in your case.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
