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]
