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]
