I've never gotten into that, and the built-in Help doesn't seem to help.
It seems to imply that a dialog will open automatically if a password is
required, which is what I'd expect, but that isn't happening for you.
Have you tried opening the mdb file both from inside Base, and by
double-clicking it? Anyway, maybe somebody else can tell you -- like
your Australian associate, who clearly has gotten into the file OK.
Mark Knecht wrote:
Barbara,
My associate in Australia replied overnight that there is a
password. However I cannot figure out in Base where I enter the
password. Where do I do that?
Thanks,
Mark
On Thu, Sep 18, 2008 at 6:41 PM, Barbara Duprey <[EMAIL PROTECTED]> wrote:
OK, send it along -- I'm on 2.4.1 and VistaHP, also, so we'll see what
happens. You won't see anything under Queries, Forms, or Reports, because
none of that comes across from Access, and Base won't test the connection at
that point.
Mark Knecht wrote:
Windows Vista Home Professional.
OO Ver. 2.4.1 Installed today but downloaded a couple of weeks ago.
File name was NDTSMain.mdb. Base didn't like it when I tried Access
2007 so that's why I went to plain Access. Trouble was that Access
support was at the top of the list but that wasn't where Base started
me in the list so I didn't see it at first. I saw the Access 2007
option in the list, tried it, failed, and then looked up at the top to
find plain Access support.
Once Base is up I can click on Queries, Forms and Files. I don't see
anything but there isn't a problem. As soon as I click on Tables I see
this message:
The connection to the data source "New Database2" could not be
established.
Not a valid password.
Everything in the Base GUI that might try to get into the databse
fails with similar messages...
I can send yo a copy of the file off list if you want to look at it.
Just let me know.
Cheers,
Mark
On Thu, Sep 18, 2008 at 2:53 PM, Barbara Duprey <[EMAIL PROTECTED]> wrote:
If the file extension is .mdb, not .mdbx, it shouldn't be an Access 2007
file. But most of the OOo versions don't yet even try to handle Office
2007
files, so that option surprises me. What platform are you on, and where
did
your OOo version come from? There may certainly be something about your
environment that's relevant to this.
Mark Knecht wrote:
Barbara,
The file is created by a program called Trading Solutions which
apparently has some version of Access in it. TS does not use any
passwords at the user interface level. However I suppose that
internally it might use a password embedded in the program that I
never see just so they can protect their intellectual property in the
database. I don't know.
To be clear, I created this .mdb file in TS myself by simply
creating a new portfolio. TS makes a new directory with all the files
but no detailed stock contents. It would normally then wait for me to
add some stocks, equations, neural networks, etc., but I only wanted
to view the default contents of the database before any of that was
added.
Base never asked for a password. It just said it was invalid.
I can create new .mdb files any time. I tried again and got the same
results.
What are the chances this is an Access revision compatibility
issue. I saw two options that said Access in the Base file type list.
The Access 2007 didn't work so I used the plain Access file type.
Maybe Base doesn't really understand the exact level of Access TS is
using...
Asking the other user for files defeats the purpose of what he and
I are trying to do, but I can certainly ask him if he used a password
to get in. I'll do that and respond back to you and NoOp later. (Might
be a day. He's in Australia, I'm in California...)
Thanks,
Mark
On Thu, Sep 18, 2008 at 12:44 PM, Barbara Duprey <[EMAIL PROTECTED]> wrote:
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]
---------------------------------------------------------------------
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]
---------------------------------------------------------------------
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]
