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]
