Re: [libreoffice-users] looking for help on Base

2011-08-04 Thread Cor Nouws

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

2011-08-04 Thread Tom Davies
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

2011-08-04 Thread Regina Henschel

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

2011-08-04 Thread Don C. Myers

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

2011-08-04 Thread Roberto Scotti
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

2011-08-04 Thread Don C. Myers

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

2011-08-04 Thread Roberto Scotti
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

2011-08-04 Thread Simon Cropper (The foss Workflow Guides)

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

2011-08-04 Thread Tom Davies
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

2011-08-04 Thread Tom Davies
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