Re: [libreoffice-users] looking for help on Base
Hi Roberto, Roberto Scotti wrote (04-08-11 10:19) When I open Base if I choose to connect to an existing database the list of available drivers doesn't include MS Access (or JET), it includes only: ... That connection is Windows only. Does this explain what you see on your computer? Regards, -- - Cor - http://nl.libreoffice.org -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] looking for help on Base
Hi :) It's probably better to stick with MS Access tbh. Base is not being actively developed and there are no plans to recruit devs for it. Hopefully some devs might stumble into the project at some point in the future and start working on the bugs. Regards from Tom :) From: Roberto Scotti roberto.sco...@gmail.com To: users@global.libreoffice.org Sent: Thu, 4 August, 2011 9:19:33 Subject: [libreoffice-users] looking for help on Base the site http://www.libreoffice.org/features/base/ states ... provides native-support drivers for some of the most-widely employed multi-user database engines: MySQL, Adabas D, MS Access... When I open Base if I choose to connect to an existing database the list of available drivers doesn't include MS Access (or JET), it includes only: JDBC JDBC Oracle Adabas D Foglio elettronico dBASE Testo MySQL ODBC How do you activate the MS Access native-support driver? Is a SQLite native-support driver available? Many thanks, Roberto Scotti -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] looking for help on Base
Hi Roberto, Roberto Scotti schrieb: the site http://www.libreoffice.org/features/base/ states ... provides native-support drivers for some of the most-widely employed multi-user database engines: MySQL, Adabas D, MS Access... When I open Base if I choose to connect to an existing database the list of available drivers doesn't include MS Access (or JET), it includes only: JDBC JDBC Oracle Adabas D Foglio elettronico dBASE Testo MySQL ODBC You can try to use ODBC, http://wiki.services.openoffice.org/wiki/Connecting_to_Microsoft_Access. But you will get mostly read access and you cannot use reports or forms from Access. Why do you need the connection? Kind regards Regina -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] looking for help on Base
Hi Tom, I've been a Base user for 7 or 8 years. As soon as Base came out I switched to it. I had first used a DOS based database, then Access, then Paradox, and then Base. For my needs, Base works very well. I used the guide from OpenOffice, Getting Started With Base to get things setup The present version can be found here, as well as other helps: http://wiki.services.openoffice.org/wiki/Database There are several small bugs in Base that are more of an annoyance than anything else. It is super fast (now that the Linux Java workaround has been found), and it is much easier to share the data between my computers than it was with Paradox. While they might not have developers working on it, there isn't anything I need to have changed. The mail merge with writer works perfectly. I've never lost any data. So even if there are not any developers working on it, I feel it is a worthy program/application. Anytime I've had an issue of needing to know how to do something, I've always been able to find an answer with on-line searches. On 08/04/2011 04:26 AM, Tom Davies wrote: Hi :) It's probably better to stick with MS Access tbh. Base is not being actively developed and there are no plans to recruit devs for it. Hopefully some devs might stumble into the project at some point in the future and start working on the bugs. Regards from Tom :) From: Roberto Scottiroberto.sco...@gmail.com To: users@global.libreoffice.org Sent: Thu, 4 August, 2011 9:19:33 Subject: [libreoffice-users] looking for help on Base the site http://www.libreoffice.org/features/base/ states ... provides native-support drivers for some of the most-widely employed multi-user database engines: MySQL, Adabas D, MS Access... When I open Base if I choose to connect to an existing database the list of available drivers doesn't include MS Access (or JET), it includes only: JDBC JDBC Oracle Adabas D Foglio elettronico dBASE Testo MySQL ODBC How do you activate the MS Access native-support driver? Is a SQLite native-support driver available? Many thanks, Roberto Scotti -- *~~* Don C. Myers e-PRO Certified by the National Association of Realtors Manager, Farm and Rural Property Division *Coldwell Banker University Realty *126 East Foster Avenue, State College, PA 16801 Office Phone: 814-237-6543 Fax: 814-237-6502 Home Phone: 814-422-8111 Cell Phone: 814-571-9518 Visit the Farm and Rural Property Division Web Site at _www.cbur-ruralproperty.com http://www.cbur-ruralproperty.com/ _View Don's Farm Web Site at www.myersfarm.com http://www.myersfarm.com/ *~~* -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] looking for help on Base
Yes, it may be. I am working on Ububntu based systems. Is it possible to install MS-Access and/or SQLite native-drivers in Linux? Many thanks, Roberto Scotti PS - I added your address in CC to be shure you would get the message, if thi causes doubling your messages please let me know. Il giorno gio, 04/08/2011 alle 10.26 +0200, Cor Nouws ha scritto: Hi Roberto, Roberto Scotti wrote (04-08-11 10:19) When I open Base if I choose to connect to an existing database the list of available drivers doesn't include MS Access (or JET), it includes only: ... That connection is Windows only. Does this explain what you see on your computer? Regards, -- - Cor - http://nl.libreoffice.org -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] looking for help on Base
Hi Roberto, Access will not run natively in Linux. I run Ubuntu 11.04 presently. I was a windows user when I switched to Base. One reason for switching was I knew someday I wanted to migrate to Linux. It was very easy since OpenOffice worked in both platforms. I run Quicken and Dreamweaver through Wine on Ubuntu. You may need to move up to Crossover Office, but it would be likely some version of Access would work. I have not researched this though. In general, some versions of Microsoft Office do work with Crossover Office. Don On 08/04/2011 10:04 AM, Roberto Scotti wrote: Yes, it may be. I am working on Ububntu based systems. Is it possible to install MS-Access and/or SQLite native-drivers in Linux? Many thanks, Roberto Scotti PS - I added your address in CC to be shure you would get the message, if thi causes doubling your messages please let me know. Il giorno gio, 04/08/2011 alle 10.26 +0200, Cor Nouws ha scritto: Hi Roberto, Roberto Scotti wrote (04-08-11 10:19) When I open Base if I choose to connect to an existing database the list of available drivers doesn't include MS Access (or JET), it includes only: ... That connection is Windows only. Does this explain what you see on your computer? Regards, -- - Cor - http://nl.libreoffice.org -- *~~* Don C. Myers e-PRO Certified by the National Association of Realtors Manager, Farm and Rural Property Division *Coldwell Banker University Realty *126 East Foster Avenue, State College, PA 16801 Office Phone: 814-237-6543 Fax: 814-237-6502 Home Phone: 814-422-8111 Cell Phone: 814-571-9518 Visit the Farm and Rural Property Division Web Site at _www.cbur-ruralproperty.com http://www.cbur-ruralproperty.com/ _View Don's Farm Web Site at www.myersfarm.com http://www.myersfarm.com/ *~~* -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] looking for help on Base
Hello Don. I have already succeded in runnin Access in some MS-widows emulation. I can also wiew and (to some extent) export info from MDB files trough GNOME MDB Viewer is a grapical interface to MDB Tools. It lets you view and export data and schema from MDB files produced by MS Access 97/2000/XP/2003. What I need now is what is claimed on the LibreOffice-Base http://www.libreoffice.org/features/base/ which states that it ... provides native-support drivers for some of the most-widely employed multi-user database engines: MySQL, Adabas D, MS Access... Many thanks, rs Nuoro Forestry School Università di Sassari http://nuoro-forestry-school.blogspot.com/ Il giorno gio, 04/08/2011 alle 10.14 -0400, Don C. Myers ha scritto: Hi Roberto, Access will not run natively in Linux. I run Ubuntu 11.04 presently. I was a windows user when I switched to Base. One reason for switching was I knew someday I wanted to migrate to Linux. It was very easy since OpenOffice worked in both platforms. I run Quicken and Dreamweaver through Wine on Ubuntu. You may need to move up to Crossover Office, but it would be likely some version of Access would work. I have not researched this though. In general, some versions of Microsoft Office do work with Crossover Office. Don On 08/04/2011 10:04 AM, Roberto Scotti wrote: Yes, it may be. I am working on Ububntu based systems. Is it possible to install MS-Access and/or SQLite native-drivers in Linux? Many thanks, Roberto Scotti PS - I added your address in CC to be shure you would get the message, if thi causes doubling your messages please let me know. Il giorno gio, 04/08/2011 alle 10.26 +0200, Cor Nouws ha scritto: Hi Roberto, Roberto Scotti wrote (04-08-11 10:19) When I open Base if I choose to connect to an existing database the list of available drivers doesn't include MS Access (or JET), it includes only: ... That connection is Windows only. Does this explain what you see on your computer? Regards, -- - Cor - http://nl.libreoffice.org -- *~~* Don C. Myers e-PRO Certified by the National Association of Realtors Manager, Farm and Rural Property Division *Coldwell Banker University Realty *126 East Foster Avenue, State College, PA 16801 Office Phone: 814-237-6543 Fax: 814-237-6502 Home Phone: 814-422-8111 Cell Phone: 814-571-9518 Visit the Farm and Rural Property Division Web Site at _www.cbur-ruralproperty.com http://www.cbur-ruralproperty.com/ _View Don's Farm Web Site at www.myersfarm.com http://www.myersfarm.com/ *~~* -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] looking for help on Base
Hi Guys, Another option if you are migrating from windows is to establish a VirtualBox that runs Windows and install Office on this. You can also do this on VMWare, although I find VirtualBox a lot faster. The Windows Platform on the VM have samba shares mapped as network drives and they are blissfully unaware that the data being accessed are on my Ubuntu filesystem. Data can be readily manipulated in a Microsoft Windows package and Linux-based package at practically the same time. VMWare also provides tools to bundle your windows box into virtual machine, although I found this carried over too much 'baggage'. I just created an empty VM using VirtualBox and reinstalled Windows and Office. On 05/08/11 00:14, Don C. Myers wrote: Hi Roberto, Access will not run natively in Linux. I run Ubuntu 11.04 presently. I was a windows user when I switched to Base. One reason for switching was I knew someday I wanted to migrate to Linux. It was very easy since OpenOffice worked in both platforms. I run Quicken and Dreamweaver through Wine on Ubuntu. You may need to move up to Crossover Office, but it would be likely some version of Access would work. I have not researched this though. In general, some versions of Microsoft Office do work with Crossover Office. Don On 08/04/2011 10:04 AM, Roberto Scotti wrote: Yes, it may be. I am working on Ububntu based systems. Is it possible to install MS-Access and/or SQLite native-drivers in Linux? Many thanks, Roberto Scotti PS - I added your address in CC to be shure you would get the message, if thi causes doubling your messages please let me know. Il giorno gio, 04/08/2011 alle 10.26 +0200, Cor Nouws ha scritto: Hi Roberto, Roberto Scotti wrote (04-08-11 10:19) When I open Base if I choose to connect to an existing database the list of available drivers doesn't include MS Access (or JET), it includes only: ... That connection is Windows only. Does this explain what you see on your computer? Regards, -- - Cor - http://nl.libreoffice.org -- Cheers Simon Simon Cropper Website Administrator http://www.fossworkflowguides.com The fossWorkflow Guides (c) Simon Cropper CC-BY-SA 3.0 Australia http://creativecommons.org/licenses/by-sa/3.0/au/deed.en -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] looking for help on Base
Hi :) It is not a good time to migrate to Base. Hopefully there are other front-ends that could be used instead? Base has no devs working on it so bug-reports are not getting fixed and there are no plans to attract devs to work on Base anytime soon. Regards from Tom :) From: Roberto Scotti roberto.sco...@gmail.com To: users@global.libreoffice.org Sent: Thu, 4 August, 2011 15:59:29 Subject: Re: [libreoffice-users] looking for help on Base Hello Don. I have already succeded in runnin Access in some MS-widows emulation. I can also wiew and (to some extent) export info from MDB files trough GNOME MDB Viewer is a grapical interface to MDB Tools. It lets you view and export data and schema from MDB files produced by MS Access 97/2000/XP/2003. What I need now is what is claimed on the LibreOffice-Base http://www.libreoffice.org/features/base/ which states that it ... provides native-support drivers for some of the most-widely employed multi-user database engines: MySQL, Adabas D, MS Access... Many thanks, rs Nuoro Forestry School Università di Sassari http://nuoro-forestry-school.blogspot.com/ Il giorno gio, 04/08/2011 alle 10.14 -0400, Don C. Myers ha scritto: Hi Roberto, Access will not run natively in Linux. I run Ubuntu 11.04 presently. I was a windows user when I switched to Base. One reason for switching was I knew someday I wanted to migrate to Linux. It was very easy since OpenOffice worked in both platforms. I run Quicken and Dreamweaver through Wine on Ubuntu. You may need to move up to Crossover Office, but it would be likely some version of Access would work. I have not researched this though. In general, some versions of Microsoft Office do work with Crossover Office. Don On 08/04/2011 10:04 AM, Roberto Scotti wrote: Yes, it may be. I am working on Ububntu based systems. Is it possible to install MS-Access and/or SQLite native-drivers in Linux? Many thanks, Roberto Scotti PS - I added your address in CC to be shure you would get the message, if thi causes doubling your messages please let me know. Il giorno gio, 04/08/2011 alle 10.26 +0200, Cor Nouws ha scritto: Hi Roberto, Roberto Scotti wrote (04-08-11 10:19) When I open Base if I choose to connect to an existing database the list of available drivers doesn't include MS Access (or JET), it includes only: ... That connection is Windows only. Does this explain what you see on your computer? Regards, -- - Cor - http://nl.libreoffice.org -- *~~* Don C. Myers e-PRO Certified by the National Association of Realtors Manager, Farm and Rural Property Division *Coldwell Banker University Realty *126 East Foster Avenue, State College, PA 16801 Office Phone: 814-237-6543 Fax: 814-237-6502 Home Phone: 814-422-8111 Cell Phone: 814-571-9518 Visit the Farm and Rural Property Division Web Site at _www.cbur-ruralproperty.com http://www.cbur-ruralproperty.com/ _View Don's Farm Web Site at www.myersfarm.com http://www.myersfarm.com/ *~~* -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] looking for help on Base
Hi :) It's good to hear some success with Base. I think it might help to have a lot of trivial issues amongst the bug-reports to help potential new devs learn their way into the code. The key word there is might. The documentation team would appreciate any help with consolidating various guides they have found and perhaps others into something like the state of the guides for the other apps but it's a major challenge because Base is unpredictably quirky between one release and another. Regards from Tom :) From: Don C. Myers donmy...@myersfarm.com To: users@global.libreoffice.org Sent: Thu, 4 August, 2011 14:34:44 Subject: Re: [libreoffice-users] looking for help on Base Hi Tom, I've been a Base user for 7 or 8 years. As soon as Base came out I switched to it. I had first used a DOS based database, then Access, then Paradox, and then Base. For my needs, Base works very well. I used the guide from OpenOffice, Getting Started With Base to get things setup The present version can be found here, as well as other helps: http://wiki.services.openoffice.org/wiki/Database There are several small bugs in Base that are more of an annoyance than anything else. It is super fast (now that the Linux Java workaround has been found), and it is much easier to share the data between my computers than it was with Paradox. While they might not have developers working on it, there isn't anything I need to have changed. The mail merge with writer works perfectly. I've never lost any data. So even if there are not any developers working on it, I feel it is a worthy program/application. Anytime I've had an issue of needing to know how to do something, I've always been able to find an answer with on-line searches. On 08/04/2011 04:26 AM, Tom Davies wrote: Hi :) It's probably better to stick with MS Access tbh. Base is not being actively developed and there are no plans to recruit devs for it. Hopefully some devs might stumble into the project at some point in the future and start working on the bugs. Regards from Tom :) From: Roberto Scottiroberto.sco...@gmail.com To: users@global.libreoffice.org Sent: Thu, 4 August, 2011 9:19:33 Subject: [libreoffice-users] looking for help on Base the site http://www.libreoffice.org/features/base/ states ... provides native-support drivers for some of the most-widely employed multi-user database engines: MySQL, Adabas D, MS Access... When I open Base if I choose to connect to an existing database the list of available drivers doesn't include MS Access (or JET), it includes only: JDBC JDBC Oracle Adabas D Foglio elettronico dBASE Testo MySQL ODBC How do you activate the MS Access native-support driver? Is a SQLite native-support driver available? Many thanks, Roberto Scotti -- *~~* Don C. Myers e-PRO Certified by the National Association of Realtors Manager, Farm and Rural Property Division *Coldwell Banker University Realty *126 East Foster Avenue, State College, PA 16801 Office Phone: 814-237-6543 Fax: 814-237-6502 Home Phone: 814-422-8111 Cell Phone: 814-571-9518 Visit the Farm and Rural Property Division Web Site at _www.cbur-ruralproperty.com http://www.cbur-ruralproperty.com/ _View Don's Farm Web Site at www.myersfarm.com http://www.myersfarm.com/ *~~* -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted