Re: [users] Microsoft Access compatibility

2008-09-19 Thread Barbara Duprey
Oops -- sorry, I know you're not opening the mdb file but trying to connect to it. It seems as if when Base tries the connection, it's recognizing the file is protected but is supplying a default "password" instead of asking for one. Barbara Duprey wrote: I've never gotten into that, and the b

Re: [users] Microsoft Access compatibility

2008-09-19 Thread Barbara Duprey
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-clicki

Re: [users] Microsoft Access compatibility

2008-09-19 Thread Mark Knecht
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 Vis

Re: [users] Microsoft Access compatibility

2008-09-18 Thread Barbara Duprey
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

Re: [users] Microsoft Access compatibility

2008-09-18 Thread Mark Knecht
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

Re: [users] Microsoft Access compatibility

2008-09-18 Thread Barbara Duprey
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 you

Re: [users] Microsoft Access compatibility

2008-09-18 Thread Mark Knecht
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 pro

Re: [users] Microsoft Access compatibility

2008-09-18 Thread Barbara Duprey
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 p

Re: [users] Microsoft Access compatibility

2008-09-18 Thread Mark Knecht
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 dat

Re: [users] Microsoft Access compatibility

2008-09-18 Thread Barbara Duprey
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,

[users] Microsoft Access compatibility

2008-09-18 Thread Mark Knecht
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 ---

Re: [users] Microsoft Access to Open Office Base ?

2008-09-12 Thread norseman
mike moller wrote: Hi Jonathon On 9/11/08, jonathon <[EMAIL PROTECTED]> wrote: On Wed, Sep 10, 2008 at 21:43, mike moller wrote: What MS Access, when included with MSO offers, is a user experience that is very nlike, and different from that of the typical database engine. What is mis

Re: [users] Microsoft Access to Open Office Base ?

2008-09-11 Thread John Jason Jordan
On Fri, 12 Sep 2008 16:33:16 +1200 "mike moller" <[EMAIL PROTECTED]> dijo: > Hi Jonathon > > On 9/11/08, jonathon <[EMAIL PROTECTED]> wrote: > > On Wed, Sep 10, 2008 at 21:43, mike moller wrote: > > > > What MS Access, when included with MSO offers, is a user experience > > that is very

Re: [users] Microsoft Access to Open Office Base ?

2008-09-11 Thread mike moller
Hi Jonathon On 9/11/08, jonathon <[EMAIL PROTECTED]> wrote: > On Wed, Sep 10, 2008 at 21:43, mike moller wrote: > > What MS Access, when included with MSO offers, is a user experience > that is very nlike, and different from that of the typical database > engine. What is missing from OO

Re: [users] Microsoft Access to Open Office Base ?

2008-09-11 Thread Barbara Duprey
John Jason Jordan wrote: On Thu, 11 Sep 2008 11:11:13 -0500 Barbara Duprey <[EMAIL PROTECTED]> dijo: John Jason Jordan wrote: I discovered that OOo Base cannot read or import Access databases. However, I also discovered that Kexi can do so. Kexi uses SQLite as its database engine. I s

Re: [users] Microsoft Access to Open Office Base ?

2008-09-11 Thread John Jason Jordan
On Thu, 11 Sep 2008 11:11:13 -0500 Barbara Duprey <[EMAIL PROTECTED]> dijo: > John Jason Jordan wrote: > > > I discovered that OOo Base cannot read or import Access databases. > > However, I also discovered that Kexi can do so. Kexi uses SQLite as its > > database engine. I successfully got my ta

Re: [users] Microsoft Access to Open Office Base ?

2008-09-11 Thread M Henri Day
2008/9/11 mike moller <[EMAIL PROTECTED]> > Thanks Henri > I wasn't aware of the Google route to acquiring StarOffice however the > limitation of not going back past XP ticks me off (same limitation > applies to their new Chrome browser too I see) I'm a long time W2k > user and it has in fact been

Re: [users] Microsoft Access to Open Office Base ?

2008-09-11 Thread Barbara Duprey
John Jason Jordan wrote: I discovered that OOo Base cannot read or import Access databases. However, I also discovered that Kexi can do so. Kexi uses SQLite as its database engine. I successfully got my tables into Kexi, although the queries, forms and such failed to transfer. I didn't have many

Re: [users] Microsoft Access to Open Office Base ?

2008-09-11 Thread mike moller
Thanks Henri I wasn't aware of the Google route to acquiring StarOffice however the limitation of not going back past XP ticks me off (same limitation applies to their new Chrome browser too I see) I'm a long time W2k user and it has in fact been these XP and later issues that have caused me to sta

Re: [users] Microsoft Access to Open Office Base ?

2008-09-11 Thread M Henri Day
2008/9/11 mike moller <[EMAIL PROTECTED]> > Hi HenriK > 8. There is an add-on for OOBase called Sun Report Builder (aka srb) > which shows promise and although released still has some way to go > before getting full functionality to match Reports in Access > > There is another path I haven't

Re: [users] Microsoft Access to Open Office Base ?

2008-09-10 Thread John Jason Jordan
On Wed, 10 Sep 2008 22:16:04 -0700 jonathon <[EMAIL PROTECTED]> dijo: > > Can Microsoft Access .mdb files be easily imported into Open Office and > > relatively used in the way the Access database creator intended? > > As MS Access files, no. > As SQLite, or Base files: Not without the end user

Re: [users] Microsoft Access to Open Office Base ?

2008-09-10 Thread jonathon
On Wed, Sep 10, 2008 at 21:43, mike moller wrote: > Sadly for my purposes I have concluded that OOBase isn't quite ready for > prime time yet so I've gone back to the MS product for the present. Much as I despise Base, I would disagree with the idea that it is not ready for prime time. What MS

Re: [users] Microsoft Access

2008-03-08 Thread Paul
> Will this program open Microsoft Access Files? > > You can connect to .mdb's just fine using ODBC and utilise the data within. The forms and other stuff that comes with MDB's however is not usable in BASE. For more info on BASE have a look at documentation.openoffice.org /paul -- For those t

[users] Microsoft Access

2008-03-08 Thread Ronald Madsen
Will this program open Microsoft Access Files? - Looking for last minute shopping deals? Find them fast with Yahoo! Search.

Re: [users] Microsoft Access Databases and OpenOffice.org on UNIX

2006-09-23 Thread James McKenzie
CPHennessy wrote: > I thought that the ODBC driver already works on Linux ( not sure about > MacOSX ). > Not according to the work that is underway. I found the issue for incorporating MDBTools into OpenOffice.org and there are many problems. > James McKenzie wrote the following: > >> I fou

Re: [users] Microsoft Access Databases and OpenOffice.org on UNIX

2006-09-23 Thread CPHennessy
On Thu September 14 2006 00:52, James McKenzie wrote: > CPHennessy wrote: > > On Fri September 8 2006 00:15, + Frances Cook wrote: > >> [ MODERATED ] > >> I have downloaded Openoffice.org 2.0 data base and wish to open an > >> existing MS Access data base which has a password

Re: [users] Microsoft Access Databases and OpenOffice.org on UNIX

2006-09-13 Thread James McKenzie
CPHennessy wrote: > On Fri September 8 2006 00:15, + Frances Cook wrote: > >> [ MODERATED ] >> I have downloaded Openoffice.org 2.0 data base and wish to open an existing >> MS Access data base which has a password which i know. How do I apply the >> password in Openoffice,

Re: [users] microsoft access (mdb) on Intel Mac OSX build

2006-08-12 Thread James McKenzie
Frank Schönheit - Sun Microsystems Germany wrote: > Hi James, > > >> If this driver is platform specific, I can ask for the source and >> attempt to get it working the the Mac platform. I will conduct a >> little more research this weekend. >> > > The driver is part of a snapshot of the CW

Re: [users] microsoft access (mdb) on Intel Mac OSX build

2006-08-11 Thread Frank Schönheit - Sun Microsystems Germa ny
Hi James, > If this driver is platform specific, I can ask for the source and > attempt to get it working the the Mac platform. I will conduct a > little more research this weekend. The driver is part of a snapshot of the CWS mdbdriver02 [1]. You will also need the mdbtools - it's a separate mod

Re: [users] microsoft access (mdb) on Intel Mac OSX build

2006-08-10 Thread James McKenzie
Brandon M. Gabler wrote: > Thanks for the tip, but by the looks of it, the one that has been > released is > for Linux, sadly, and not Mac. That being said, will Mac recognize the > linux > driver? > If the driver is Java based, it will not matter what the platform is. If this driver is platform s

Re: [users] microsoft access (mdb) on Intel Mac OSX build

2006-08-10 Thread G. Roderick Singleton
On Thu, 2006-08-10 at 16:09 -0700, Brandon M. Gabler wrote: > Thanks for the tip, but by the looks of it, the one that has been released is > for Linux, sadly, and not Mac. That being said, will Mac recognize the linux > driver? > For Mac questions like this one, your best bet is to subscribe to

Re: [users] microsoft access (mdb) on Intel Mac OSX build

2006-08-10 Thread Brandon M. Gabler
Thanks for the tip, but by the looks of it, the one that has been released is for Linux, sadly, and not Mac. That being said, will Mac recognize the linux driver? -- Brandon M. Gabler Research Associate Department of Anthropology 1009 E South Campus Drive, Building #30A University of Arizona Tuc

Re: [users] microsoft access (mdb) on Intel Mac OSX build

2006-08-10 Thread G. Roderick Singleton
On Thu, 2006-08-10 at 13:08 -0700, Brandon M. Gabler wrote: > Hi all, > > I just installed the newly released english version of open office on my intel > mac, and need to be able to open, or at least import all tables, queries, > etc., > from mdb files. > > Can Open office do this directly, or

[users] microsoft access (mdb) on Intel Mac OSX build

2006-08-10 Thread Brandon M. Gabler
Hi all, I just installed the newly released english version of open office on my intel mac, and need to be able to open, or at least import all tables, queries, etc., from mdb files. Can Open office do this directly, or do I need to save them out of access individually first as dbf files? Thanks

Re: [users] Microsoft Access

2006-02-18 Thread CPHennessy
On Thu February 16 2006 19:01, feorlen wrote: > I would like to convert an existing MS Access MDB file into something > I can use with Base. Various archived messages suggest different > things, including some rather detailed instructions from last month > that seem to have no relation to the versi

[users] Microsoft Access

2006-02-16 Thread feorlen
I would like to convert an existing MS Access MDB file into something I can use with Base. Various archived messages suggest different things, including some rather detailed instructions from last month that seem to have no relation to the version I am running. If you are using OOo2.0. you

Re: [users] Microsoft Access

2006-01-15 Thread Jean Hollis Weber
Kim Fournier wrote: I'm sure this is all very straightforward and it's just me not seeing the forest for the trees, but looking at page 1 of the Getting Started document, why don't I have an Open Office icon anywhere that opens to a nice window with a menu and toolbars like the graphic shown? I

Re: [users] Microsoft Access

2006-01-15 Thread Kim Fournier
TED]> To: Sent: Sunday, January 15, 2006 8:12 PM Subject: Re: [users] Microsoft Access Kim Fournier wrote: Can my Access files be converted/opened in Open Office Base? I haven't had any luck doing that so far. All I get is a few lines of ASCII Any and all advice is welcomed. If yo

Re: [users] Microsoft Access

2006-01-15 Thread Kim Fournier
Thank you, Jean. k . . . . . - Original Message - From: "Jean Hollis Weber" <[EMAIL PROTECTED]> To: Sent: Sunday, January 15, 2006 8:12 PM Subject: Re: [users] Microsoft Access Kim Fournier wrote: Can my Access files be converted/opened in Open Office Base? I

Re: [users] Microsoft Access

2006-01-15 Thread Jean Hollis Weber
Kim Fournier wrote: Can my Access files be converted/opened in Open Office Base? I haven't had any luck doing that so far. All I get is a few lines of ASCII Any and all advice is welcomed. If you are using OOo2.0. you should be able to do this using the Database Wizard. To start the Wiza

[users] Microsoft Access

2006-01-15 Thread Kim Fournier
Hi - Help? Can my Access files be converted/opened in Open Office Base? I haven't had any luck doing that so far. All I get is a few lines of ASCII. I just download Open Office 2 this afternoon. The 60-day trial version of Microsoft Office on my new computer expires in a month.

Re: [users] Microsoft Access Files

2005-12-24 Thread CPHennessy
On Fri December 16 2005 17:21, + Matthew McLaughlin wrote: > [ MODERATED ] *** > Dear Sirs, > > What ODBC drivers would I need to use Microsoft Access > Files (.mdb) in Open Office Base? Where would I get > these drivers? As you are not subscribed you may not have seen that:

Re: [users] Microsoft Access Files

2005-12-16 Thread G. Roderick Singleton
On Fri, 2005-12-16 at 09:21 -0800, Matthew McLaughlin wrote: > Dear Sirs, > > What ODBC drivers would I need to use Microsoft Access > Files (.mdb) in Open Office Base? Where would I get > these drivers? You should also be able to use your ADO driver. Should be in the list. -- PLEASE KEEP MESSA

[users] Microsoft Access Files

2005-12-16 Thread Matthew McLaughlin
Dear Sirs, What ODBC drivers would I need to use Microsoft Access Files (.mdb) in Open Office Base? Where would I get these drivers? Thanks, Matthew M. McLaughlin [EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam p