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]
